Vlookup question

[wazupsc]

i AM USING THE VLOOKUP FUNCTION TO LOOK UP A DESCRIPTION. iF THERE IS NO VALE ENTERNED IN THE VLOOKUP CELL, I WOULD LIKE THE DESCRIPTION TO BE BLANK RATHER THEN SHOWING #N/A. BUT WOULD LIKE THE FORMULAR TO REMAIN. IS THAT POSSIBLE?

 

[Jonmo1]

Welcome to the board...

Here's basic syntax, depending on which version of XL you have..

XL2003 or earlier

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

XL2007 or higher

=IFERROR(VLOOKUP(...),"")


Hope that helps.

 

[Trevor G]

Please don't type your question in capitals it represents your shouting at people.

You can use an IF statement around the VLOOKUP to say if the cell has a value then use the VLOOKUP at the true element and place in no text if false, follow what I have done in Red

=IF(B2>0,VLOOKUP(B2,TableRange,Column,False),"")