Excel

  • Thread starter Thread starter Sudent, Lucille
  • Start date Start date
S

Sudent, Lucille

Taking the excel course. What function or formula do I use to look-up a
name or number from a different worksheet. Then I want nest the function in
an IF statement so that if any information is missing, blank cells will be
displayed. Thank you. I must have gone brain dead from all the studying.
 
Use VLOOKUP(). To get the required blank if the lookup fails, use something
like

=IF(ISERR(VLOOKUP()),"",VLOOKUP())
 
Thank you
Lucille

Gary''s Student said:
Use VLOOKUP(). To get the required blank if the lookup fails, use something
like

=IF(ISERR(VLOOKUP()),"",VLOOKUP())
Click to expand...
 
You must log in or register to reply 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 VBA 1
solving nested IF statements 13
Named Range question 9
Excel Concatenate with line breaks but ignore blank cells 3
Values not showing in either cell or formula bar 2
Excel Formula / Programming 3
conditional minimum formula 7
Formula Audit mode active in one column only; cannot kill. 2

Back
Top