Vlookup
 

I am doing a vlookup to bring back multiple columns of information, but I am
having a problem getting the rows to be blank if there is no 'starting' data.
I am working on a purchase order sheet and if there is nothing ordered I
want the formula to be there, but be blank if they are only ordering two
items instead of ten.

Vlookup
 

be blank if there is no 'starting' data.

Assuming "starting data" means the lookup value:

=IF(A1="","",your VLOOKUP function here))

--
Biff
Microsoft Excel MVP


"AmyLRuck" wrote in message
...
I am doing a vlookup to bring back multiple columns of information, but I
am
having a problem getting the rows to be blank if there is no 'starting'
data.
I am working on a purchase order sheet and if there is nothing ordered I
want the formula to be there, but be blank if they are only ordering two
items instead of ten.