LOOKUP instead of Index and Match

F

frankjh19701

I have an Excel spreadsheet with inventory numbers on it from variou
distribution centers. They come with their names, dates, commodit
amounts, etc each day. What I want to do is set up a formula that wil
find the center's number in Column A and return the commodity amoun
from Column C. Also, if the center's number isn't found, then I woul
like for it to return "0", or N/A, or something like that to show th
number wasn't found.

I've been trying to use:

LOOKUP(E1+100,CHOOSE({1,2},0,INDEX($K$2:$K$24,MATCH(1,INDEX(($H$2:$H$24=$H$12)*($K$2:$K$24=$K$12),),))))

But, I can't seem to configure it to my needs.

Any/all assistance is greatly appreciated.

Thank yo
 
S

Spencer101

frankjh19701;1170646 said:
I have an Excel spreadsheet with inventory numbers on it from variou
distribution centers. They come with their names, dates, commodit
amounts, etc each day. What I want to do is set up a formula that wil
find the center's number in Column A and return the commodity amoun
from Column C. Also, if the center's number isn't found, then I woul
like for it to return "0", or N/A, or something like that to show th
number wasn't found.

I've been trying to use:

LOOKUP(E1+100,CHOOSE({1,2},0,INDEX($K$2:$K$24,MATCH(1,INDEX(($H$2:$H$24=$H$12)*($K$2:$K$24=$K$12),),))))

But, I can't seem to configure it to my needs.

Any/all assistance is greatly appreciated.

Thank you
Click to expand...

Hi, any chance you could show us an example of the workbook to make i
easier to understand the issue
 
Top