Excel

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.
 
G

Gary''s Student

Use VLOOKUP(). To get the required blank if the lookup fails, use something
like

=IF(ISERR(VLOOKUP()),"",VLOOKUP())
 
S

Sudent, Lucille

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...
 
Top