Formula - IFERROR?

[Spaztic]

Need a little help here. The example below shows that the user will enter a color (types it in). I want the Answer to:
1) If it's in the lookup, return the value
2) If it's left blank, return blank
3) If something is entered and not in the lookup, return blank

 

[Alex Blakenburg]

Using XLookup below:

Book1
	B	C	D	E
4	Enter		Red	225
5	Blue		Blue	720
6			Green	340
7	Answer		Yellow	110
8	720		Orange	620
Sheet1

Cell Formulas
Range	Formula
B8	B8	=IF(B5="","",XLOOKUP(B5,D4:D8,E4:E8,""))

VLookup equivalent:

=IF(B5="","",IFERROR(VLOOKUP(B5,D4:E8,2,FALSE),""))

 

[Spaztic]

Thank you! Works exactly as I wanted it to!

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.