Excel Formula Help Needed?

1 ⤊

Excel Formula Help Needed?

Does Anyone know know the formula that puts a vlookup into an =IF statement that will cause the result to display a blank cell (“”) if the vlookup is false?

2006-10-19 09:34:36 · 3 answers · asked by BIGBRI4348 1 in Computers & Internet ➔ Programming & Design

3 answers

=IF( ISERROR( VLOOKUP( bla bla bla )), "", VLOOKUP( bla bla bla )))

Enjoy my profile here, I am VBAXLMan

2006-10-21 02:26:39 · answer #1 · answered by Anonymous · 0⤊ 0⤋

assuming you know how to use the VLOOKUP function,
the formula should be
=IF(ISNA(VLOOKUP(...))=TRUE , "" , VLOOKUP(...) )

2006-10-19 09:44:11 · answer #2 · answered by Anonymous · 1⤊ 0⤋

Yes, I do.

2006-10-19 09:43:12 · answer #3 · answered by MOM W 2 · 0⤊ 1⤋