Vlookup

  • Thread starter Thread starter AmyLRuck
  • Start date Start date
A

AmyLRuck

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.
 
be blank if there is no 'starting' data.

Assuming "starting data" means the lookup value:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vlookup Help 0
IF ERROR FORMULA 2
VLOOKUP Problem 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Counting numeric but not Alpha 2
VLOOKUP Function 8
Vlookup help 2
IFERROR TO COMPARE WKSHEET 2

Back
Top