#N/A via Vlookup to produce name from other worksheet
I have names in worksheets E & T. Mosdt names are in bith sheets, though some
that are in E are not in T. I have this formula in the H column of worksheet A. IF('C'!E20,VLOOKUP('C'!E2,'T'!$B$3:$I$700,2,FALSE ),"") It produces either names from Worksheet C if employee found in E2 is also found in worksheet T, or #N/A if they're not found in Worksheet T. I'd like to have a formula in the K column of worksheet A that will produce the name of the employee from worksheet C that is NOT FOUND in worksheet T. And if an employee is found in both worksheets, then nothing "" in that cell in the K column. Something like: If names on both sheets, "", if not, "Smith". I hope this makes sense. Thanks, Steve |
#N/A via Vlookup to produce name from other worksheet
Try the below formula in Sheet 'T' in a unused column (say G). The formula
will check whether the name in Sheet T cell E2 exists in SheetC col B..If it is present the formula will return a blank and if present return the name itself in ColG...copy down as required.... =IF(COUNTIF('C'!B:B,E2),"",E2) If this post helps click Yes --------------- Jacob Skaria "Steve" wrote: I have names in worksheets E & T. Mosdt names are in bith sheets, though some that are in E are not in T. I have this formula in the H column of worksheet A. IF('C'!E20,VLOOKUP('C'!E2,'T'!$B$3:$I$700,2,FALSE ),"") It produces either names from Worksheet C if employee found in E2 is also found in worksheet T, or #N/A if they're not found in Worksheet T. I'd like to have a formula in the K column of worksheet A that will produce the name of the employee from worksheet C that is NOT FOUND in worksheet T. And if an employee is found in both worksheets, then nothing "" in that cell in the K column. Something like: If names on both sheets, "", if not, "Smith". I hope this makes sense. Thanks, Steve |
#N/A via Vlookup to produce name from other worksheet
Thank you. Worked great. And a lot simplier/cleaner than I was expecting.
Thanks again, Steve "Jacob Skaria" wrote: Try the below formula in Sheet 'T' in a unused column (say G). The formula will check whether the name in Sheet T cell E2 exists in SheetC col B..If it is present the formula will return a blank and if present return the name itself in ColG...copy down as required.... =IF(COUNTIF('C'!B:B,E2),"",E2) If this post helps click Yes --------------- Jacob Skaria "Steve" wrote: I have names in worksheets E & T. Mosdt names are in bith sheets, though some that are in E are not in T. I have this formula in the H column of worksheet A. IF('C'!E20,VLOOKUP('C'!E2,'T'!$B$3:$I$700,2,FALSE ),"") It produces either names from Worksheet C if employee found in E2 is also found in worksheet T, or #N/A if they're not found in Worksheet T. I'd like to have a formula in the K column of worksheet A that will produce the name of the employee from worksheet C that is NOT FOUND in worksheet T. And if an employee is found in both worksheets, then nothing "" in that cell in the K column. Something like: If names on both sheets, "", if not, "Smith". I hope this makes sense. Thanks, Steve |
All times are GMT +1. The time now is 10:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com