IF..., then....

G

Guest

If value in cell a1 = value in cell a2 or a3 or a4, then display the value in
cell b2 in cell c2
If value in cell a1 = value in cell a5 or a6 or a7, then display the value
in cell b5 in cell c2
If value in cell a1 = value in cell a8 or a9, then display the
value in cell b8 in cell c2
 
M

Max

One way, assuming the checking is to be in the sequence as posted ..

Put in C2:

=IF(A1="","",
IF(OR(A1=A2,A1=A3,A1=A4),B2,
IF(OR(A1=A5,A1=A6,A1=A7),B5,
IF(OR(A1=A8,A1=A9),B8,""))))
 
B

Beege

JcR said:
If value in cell a1 = value in cell a2 or a3 or a4, then display the value
in
cell b2 in cell c2
If value in cell a1 = value in cell a5 or a6 or a7, then display the value
in cell b5 in cell c2
If value in cell a1 = value in cell a8 or a9, then display the
value in cell b8 in cell c2
Click to expand...

=IF((OR(A1=A2,A1=A3,A1=A4)),B2,(IF((OR(A1=A5,A1=A6,A1=A7)),B5,(IF((OR(A1=A8,A1=A9)),B8,"")))))

Beege
 

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

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
How to look for value? 1
Using two Vlookup in one Cell 1
Finding last cell with a value and then adding to another 2
change the color of cell background based on a result 2
Using a formula to select a cell using the row and column values 7
VLookup formula question 2
need a formula 7

Top