lookup multiple values



Assuming the following table of categories and values:
1 cat1 val1
2 cat2 val2
3 cat3 val3
4 cat1 val4
5 cat2 val5

I need to lookup multiple values for the same category: Ex: if in cell C1 i
lookup cat1 it returns val1, then if in cell D1 i lookup cat1 it returns val4.

Thanks in advance for any help.


In C1

Entered with Ctrl+shift+Enter rather than just enter. then select C1 and
drag fill to the right until you get an error returned.

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