using an if function for blank data

M

Matt

Hi,
I want to use an IF function attached to a vlookup that
will display blank data in each of the columns if an item
number is not selected. For example, if nothing is
entered in my item column, I don't want the N/A displayed,
I just want a blank there. In my item column I have
another vlookup that displays the description of the item
automatically, I just need the blanks to be displayed when
nothing is entered.

Thanks
 

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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Adding data to MS Access from csv file 0
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Excel does not accept text format! 0
Using the list form control: multi-selection possible? 3
Publisher is filling blank lines with data 2
Consolidation Table from Different Excel Tabs with Different Format 1
Populate a table based on check box status 2

Top