Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|