vlookup returns n/a

T

Todd L.

Hi, can someone see where I am going wrong with this vlookup?


=VLOOKUP(Totals!F4,'Manufacturer Codes'!A8:I174,5,FALSE)


Totals!f4= 3/8* Cheer 2.2 lb Prime Foam

the exact match is in 'Manufacturer Codes' C70 ( 3/8* Cheer 2.2 lb Prime Foam
)

the return I want is in 'Manufacturer Codes' G70

The formula is in Totals!F5


Thanks


Todd
 
D

Domenic

Try the following formula...

=INDEX('Manufacturer Codes'!G8:G174,MATCH(Totals!F4,'Manufacture
Codes'!C8:C174,0))

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same forumula returns both 0 & N/A 2
trouble with (complicated) vlookup searching another workbook 2
Referring to a cell by using another cell for the row number 6
Vlookup error 1
Multiple VLOOKUP in an IF statement 2
IF statement with 2 logicals 1
Vlookup 1
Totaling VLookup 2

Top