Pasting in cells from a .csv exported report. VLOOKUP is not populating on sheet.

I have a workbook I am putting together for a customer. I have a formula in column E on sheet one that should be populating based data pasted into sheet 2. That formula is:

=IF(ISNA(VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,3,)FALSE),"",VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,3,)FALSE))

I am pasting in data from the .csv export into columns A and B on sheet 2. The expectation is that the values from column B on sheet 2 will appear in column E on sheet 1. This works if I manually place test data in sheet 2 or if I copy/paste values from another spreadsheet. What could be causing this to not populate. I get no errors, just a blank column E.

Column A sheet 2 and Column B sheet 1 are both number formatted, custom, with a format of 00000-0000-00.

Thanks.

First of all: Your VLOOKUP should be structured as follows:

=VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,3,FALSE) not sure where you got the extra parentheses from.

Also, you can't pull the third column =VLOOKUP(Sheet1!B2,Sheet2!$A$2:$B$600,3,FALSE) out of $A$2:$B$600 - there are only two columns in that. It should give you a #REF error.

So assuming you want values from column B on Sheet2, your final formula should be

=IF(ISNA(VLOOKUP(B2,Sheet2!$A$2:$B$600,2,FALSE)),"",VLOOKUP(B2,Sheet2!$A$2:$B$600,2,FALSE))

Thanks for the replies.

The 3 in my VLOOKUP was just a typo. It was correct on the actual worksheet.

I copies in what BenMiller provided and it still did not populate any values. However, if I manually enter values in column B, sheet 2 that match values in column A, sheet 1, it works. Also, if I copy values from another workbook it also works fine. However, if I paste in values from the .csv, it still just leaves my column E blank.

There must be something in the data that I am pasting in that is causing an issue.

What happens if you run the VLOOKUP by itself, without the IF(ISNA( around it?