Nested IF statement and VLOOKUP

[matty_lou82]

Hi - I need a nested If and VLOOKUP statement, so that if a reference cell contains text, the formula cell returns what text is in the reference cell in the first instance. However if there is no text in the original reference cell, a VLOOKUP is instead applied to an adjacent different reference cell, which contains a lookup value which returns the text derived from a separate table array.

So in the instance of the attached image, In cell E3, because cell C3 contains text, the text written in cell C3 is to be returned in cell E3.

However in cell E4, because in the first instance there is no text to return in cell C4, apply a VLOOKUP to the lookup value in cell B4 using the table array given, subsequently returning "CV/App Form Not Suitable" in cell E4.

I would really appreciate any help, TIA.

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	A	B	C	D	E
1
2
3		12345	A		A
4		12345			C
5		12347	B		B
6
7
8
9
10		12345	C
11		99999	D
12		12347	E
13		22222	F
14		33333	G
Sheet1044

Cell Formulas
Range	Formula
E3:E5	E3	=IF(C3="",VLOOKUP(B3,B$10:C$14,2,0),C3)

 

[matty_lou82]

Hi,

Try this:

Book3.xlsx
	A	B	C	D	E
1
2
3		12345	A		A
4		12345			C
5		12347	B		B
6
7
8
9
10		12345	C
11		99999	D
12		12347	E
13		22222	F
14		33333	G
Sheet1044

Cell Formulas
Range	Formula
E3:E5	E3	=IF(C3="",VLOOKUP(B3,B$10:C$14,2,0),C3)

Perfect, thank you, this is extremely helpful!

 

[jtakw]

You're welcome, thanks for the feedback.