You need to change the 1 just before the ,FALSE to 2 if you want to get the data from column B, but that isn't the cause of your problem. You will get the #N/A error if you are looking for an exact match (signified by the FALSE at the end of your formula) and there isn't one. If you think there is an exact match then it might be (if you are using numbers) that the numbers on one sheet are proper numbers, but the numbers on the other sheet are actually text values which just look like numbers. If you are looking up text values then you might have extra spaces in one sheet compared with the other.

If you post an example file with the errors in then I can take a look for you.

Hope this helps.

Pete