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.