modify vlookup
 

=VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
no in formation is entered in A19 it remains blank. I am currently getting
#na.

modify vlookup
 

=IF(A19="","",VLOOKUP(A19,Product!A7:B13,2,FALSE))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cuffie" wrote in message ...
| =VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
| no in formation is entered in A19 it remains blank. I am currently getting
| #na.

modify vlookup
 

"Niek Otten" wrote:

=IF(A19="","",VLOOKUP(A19,Product!A7:B13,2,FALSE))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cuffie" wrote in message ...
| =VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
| no in formation is entered in A19 it remains blank. I am currently getting
| #na.

modify vlookup
 

Thank you, I will try it.

"Niek Otten" wrote:

=IF(A19="","",VLOOKUP(A19,Product!A7:B13,2,FALSE))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cuffie" wrote in message ...
| =VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
| no in formation is entered in A19 it remains blank. I am currently getting
| #na.

modify vlookup
 

IF(ISNA(VLOOKUP(A19,Product!A7:B13,2,FALSE)),0,VLO OKUP(A19,Product!A7:B13,2,FALSE))


"cuffie" wrote:

=VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the if
no in formation is entered in A19 it remains blank. I am currently getting
#na.

modify vlookup
 

Shorter:

=IF(A19="","",VLOOKUP(A19,Product!A7:B13,2,0))


--
Biff
Microsoft Excel MVP


"yusuf" wrote in message
...
IF(ISNA(VLOOKUP(A19,Product!A7:B13,2,FALSE)),0,VLO OKUP(A19,Product!A7:B13,2,FALSE))


"cuffie" wrote:

=VLOOKUP(A19,Product!A7:B13,2,FALSE) I need to modify this formula so the
if
no in formation is entered in A19 it remains blank. I am currently
getting
#na.