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.
Ive checked if the values match with =B2=B2=True
Hope somebody has a solution for me!! I've attached the sample data
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.
Ive checked if the values match with =B2=B2=True
Hope somebody has a solution for me!! I've attached the sample data