![]() |
#1
|
|||
|
|||
![]()
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. |
Tags |
n/a, text, vlookup |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jyfuller | Excel | 15 | 09-21-2012 11:35 AM |
IF + VLOOKUP formula help | skyline255 | Excel | 0 | 09-19-2012 05:05 PM |
Help with VLOOKUP formula | pattyr | Excel | 6 | 08-20-2012 02:20 AM |
formula to work from data column | masterdineen | Excel | 16 | 08-09-2012 07:52 AM |
![]() |
vthomeschoolmom | Excel | 1 | 04-18-2012 02:29 PM |