Lookup, vlookup, find, or what
Thanks in advance. Xcel07 on WinXP.
I have a list of names in sheet 4, I need to search sheet 1, 2 and 3 to see if each name on sheet4 is located on any of the other 3 sheets. Here are a couple of my attempts so far =LOOKUP(C3,'Friday 930am:Monday 1130am'!C2:C25) =SUMPRODUCT(C2*'Friday 930am:Monday 1130am'!C2:C25) To clarify the above Sheet 1 is named Friday 930am Sheet 2 is anmed Friday 12:30pm Sheet 3 is named Monday 1130am Any suggestions are welcome |
Lookup, vlookup, find, or what
You can't do that type of 3D referencing. Need to individually look through
each sheet =ISNUMBER(MATCH(C2,'Friday 930am'!C2:C25))+ ISNUMBER(MATCH(C2,'Friday 12:30pm'!C2:C25))+ ISNUMBER(MATCH('Monday 1130am'!C2:C25)) Anything greater than 0 indicates a match was found. -- Best Regards, Luke M "JR Hester" wrote in message ... Thanks in advance. Xcel07 on WinXP. I have a list of names in sheet 4, I need to search sheet 1, 2 and 3 to see if each name on sheet4 is located on any of the other 3 sheets. Here are a couple of my attempts so far =LOOKUP(C3,'Friday 930am:Monday 1130am'!C2:C25) =SUMPRODUCT(C2*'Friday 930am:Monday 1130am'!C2:C25) To clarify the above Sheet 1 is named Friday 930am Sheet 2 is anmed Friday 12:30pm Sheet 3 is named Monday 1130am Any suggestions are welcome |
Lookup, vlookup, find, or what
one way
=COUNTIF('friday 930am'!C2:C25,A3)+COUNTIF('friday 1230pm'!C2:C25,A3)+COUNTIF('monday 1130am'!C2:C25,A3) a3 being what you are looking for it will count how many times it is on each page "JR Hester" wrote: Thanks in advance. Xcel07 on WinXP. I have a list of names in sheet 4, I need to search sheet 1, 2 and 3 to see if each name on sheet4 is located on any of the other 3 sheets. Here are a couple of my attempts so far =LOOKUP(C3,'Friday 930am:Monday 1130am'!C2:C25) =SUMPRODUCT(C2*'Friday 930am:Monday 1130am'!C2:C25) To clarify the above Sheet 1 is named Friday 930am Sheet 2 is anmed Friday 12:30pm Sheet 3 is named Monday 1130am Any suggestions are welcome |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com