Vlookup not working?

[Lmaonade]

Hi guys, I've used Vlookups a few times and testing something here... why is this cell returning 0? Instead of the 6 that I'm thinking it should? Without the "IFERROR" it returns "N/A" Not sure why it's not grabbing the 6 from the holiday days as "paris" matches this row? Maybe I'm doing something very wrong. I just don't understand.

 

[jproffer]

Your data is very small and hard/impossible to see. What is the formula? And what columns and row are the lookup value, and the expected result in?

 

[Lmaonade]

Hi! Not sure why it came up so small!

 

[Lmaonade]

Ok I think I figured it out. I guess I have to make the data start at the same colomn as the search. So for this test I would need to start the search data from Colomn E rather than from the whole table?

I didn't know that the VLookup search data has to start at the same colomn.

 

[JonXL]

Ok I think I figured it out. I guess I have to make the data start at the same colomn as the search. So for this test I would need to start the search data from Colomn E rather than from the whole table?

I didn't know that the VLookup search data has to start at the same colomn.

Yes, VLOOKUP searches the left-most column of the range you specify for the search value and returns the value in the cell of the same row x columns to the right.


https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1