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.