LOOKUP instead of Index and Match
I have an Excel spreadsheet with inventory numbers on it from various distribution centers. They come with their names, dates, commodity amounts, etc each day. What I want to do is set up a formula that will find the center's number in Column A and return the commodity amount from Column C. Also, if the center's number isn't found, then I would like for it to return "0", or N/A, or something like that to show the number wasn't found.
I've been trying to use:
LOOKUP(E1+100,CHOOSE({1,2},0,INDEX($K$2:$K$24,MATC H(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
|