Hi guys,

Really desperate for your help here. Can’t get my head around why this formula does not work. Im using excel 2002 and trying to used If with such condition:

=IF(VLOOKUP(A1;[Input.xls]Sheet1!$A$1:$B$5;2;0)=”OK”;”OK”;VLOOKUP(A1;[Input.xls]Sheet2!$A$1:$B$5;2;0))

It only retrieves the 1st vlookup (fist 5 entries), but does not retrieves the result of 2nd vlookup (if false). It gives the following results:

1111 | OK |

2222 | OK |

3333 | OK |

4444 | OK |

5555 | OK |

6666 | #N/A |

7777 | #N/A |

8888 | #N/A |

9999 | #N/A |

11110 | #N/A |

I’ve got two files, one output file and one input file with two sheets where the vlookups need to pick the data from.

Your help would be really appreciated.

/Andy.