Thread: Vlookup help

Hi there:

I am using a Vlookup and for some reason, it returens some values, but not others? I can clearly see the data in the other file, but my Vlookup is only worlking on some cells? IS ist a cell formatting issue?

make sure you make your range static instead of dynamic e.g. =vlookup(A1,$B$1:$D$20,2,false). The dollar signs make the range not move as you drag your vlookup.

did, that, thanks. still have the same issue

if you use false it will look for full matches, true will look for partial matches. If you're using false and there isn't an exact match, it won't return a result. Can you post an example of your spreadsheet?

It's work related and proprietary, unfortunately

example.xlsx

here's an example. the N/A's are where the vloopup is not being returned.

upload a sample of your current workbook with the vlookup, but sanitize the data with ctrl+h

I'll do 2: a workbook with the 2 columns fullof data, and another with the 1 column and where I am doing the vlookup

file 1.xlsxfie 2.xlsx

so this example is what is happening to you?scottrotondo_example.xlsx

Yes. Sheet 1 has 2 columns of data. I am trying to do a vlookup in sheet 2, where the first column is populated, and I want to get the data from sheet 1, column 2. As you can see, some data comes over, but not all. Could the cells be formatted oddly??

THANK YOU guys soooo much!!! Worked perfetly!