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. |
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. |
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. |
All times are GMT +1. The time now is 09:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com