Return blank when no data in vlookup formula

[Chris Fawcett]

Hi All,

I have a vlookup formula in which the table will not always have a value and will return N/A. Is there a way I can return "" blank instead e.g using an IF formula etc? The formula is

=VLOOKUP(Y172,$E$129:$F$180,2,FALSE)

Kind Regards

Chris

[berlan]

Try,

=IFERROR(VLOOKUP(Y172,$E$129:$F$180,2,FALSE),"")

Cheers,
berlan

[Chris Fawcett]

Thanks :-)

[berlan]

You're welcome, thanks for the rep.