I've searched the web and can't find a solution to my problem with excel mac 2011.

My lookup_values are a combination of both text and numbers (they are manufacturer's part number in Column C).
This is my formula =VLOOKUP(C4:C204,Sheet1!A1:AV86,34,0). I need Delivery Time which corresponds to the other worksheet in Column AH (C34)

I believe the problem is with my data rather than my formula but not sure how to solve it. there's no trailing space, i cleared formats, etc. But I'm still getting the dreaded #N/A value.
I Command F to for the part number and it finds it in the other spreadsheet fine, so don't the values match?



Hope somebody has a solution for me!! I've attached the sample data.

Attached Files

vlookuphelp.xlsx (90.2 KB, 13 views)

The values on the two sheets are the same, I used the formula =Cell=Cell=True

What's going on? No troubleshooting tips work!

I hope this is what your looking to achive

Attached Files

Copy of Xl0000403.xls (218.5 KB, 11 views)

I attached a solution making full use of the capacities of INDEX.
For it to work, column headers must be the same
(Hope it's OK for the MAC version)

Attached Files

Xl0000403_gen.xls (303.0 KB, 9 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post