Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find exact value using LOOKUP | Excel Discussion (Misc queries) | |||
Lookup / find value in column which changes | Excel Worksheet Functions | |||
Lookup...find next | Excel Discussion (Misc queries) | |||
Lookup Value and find Corresponding Value on another row same column | Excel Discussion (Misc queries) | |||
Find and replace with a lookup | Excel Worksheet Functions |