I have automated a sheet to populate the value of a specific item using the
IF, VLOOKUP formulas.

Everything is great, but at the very end I am getting an error in the last
field

- F13 is empty until i enter a number (quantity)

- in G13 I have the following which auto pulls up a price for a # entered in
a previous cell

=IF(D13="","",VLOOKUP($E13,$E69:$F$144,COLUMN(B51) ,0))

- in H13 I have the following,

=F13*G13

If F13 and G13 are blank, I get the "#VALUE1" error. I need that to be
blank or zero, but can't figure out how. Please help!


Column | F13 | G13 | H13
|
Formula | | (=IF(D13..etc.) | (=F13*G13) |
Excel Shows | | | #VALUE!
|