Lookup, index, match?

K

Kikuchisawa

I'm trying to link a order log with inventory to decide whether to order or
not.
Inventory have 22 type of supplies. But I can't get it to connect between
the formula, I want to used "IF" but the function will not accomodate, Lookup
value get me #N/A. Can anyone gave me any idea??
 

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

trouble with (complicated) vlookup searching another workbook 2
First row where a cell is zero 2
match formula 2
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
VLOOKUP, MATCH, INDEX HELP! 5
Index lookup with multiple match criteria 5
LOOKUP instead of Index and Match 1
Drop down list from index/match formula 1

Top