Excel
Thank you
Lucille
"Gary''s Student" wrote:
Use VLOOKUP(). To get the required blank if the lookup fails, use something
like
=IF(ISERR(VLOOKUP()),"",VLOOKUP())
--
Gary''s Student - gsnu200805
"Sudent, Lucille" wrote:
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.
|