Use an If function to result in more then one answer

M

mwear

Is it possible if you had this (see below, tab 2) on one tab to have another
tab that has a cell that would reference what is in row A and result in row
B. Sometimes row B will be the same for each group of what's in row A and
sometimes it will be different. So, say it would say if I would put a
formula in row D to reference row C to look up on different tab row A to get
the answer(s) from row B.

tab 1
C D
12345 Chicago
67891 Chicago, Denver

tab 2
A B
1 12345 Chicago
2 12345 Chicago
3 12345 Chicago
4 67891 Denver
5 67891 Denver
6 67891 Chicago

HOpe all that made sense.

THanks in advance for the help.
 

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

combining =SEARCH & =IF statements 4
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Lookup with 2 criteria 2
Document Merge Formatting Issue 0
Relevant user should see only his data 0
How to set One value from Multiple Lookup Value 3
Use Formula to sort two strings 2
How can I count deviations between two rows? 4

Top