Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there,
looking for a little help with the following: I have 18 Groups listed in Column G In Columns H to S I have numbers rangings from 0-40. Each group corresponds to 12 numbers(ex.Group A-0,3,4,5,7,11,33,34,35,36,37,40) Some groups have some of the same numbers, but not all numbers match. What I would like is for Column C to lookup the group in B2 and compare it to the group in B3 and if any of the numbers within the 2 groups match, give me "MATCH" in C3. If no match, then "MISS" in C3. A quick example: B2 contains Group F B3 contains Group C I would like C3 to compare the numbers in Group F and Group C and tell me if any of the 12 numbers in each group are the same. If they are, I want a "MATCH" in C3. Thanks a bunch! Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP, IF and multiple columns | Excel Discussion (Misc queries) | |||
vlookup for multiple columns | Excel Worksheet Functions | |||
Multiple Columns & VLookup?? | Excel Worksheet Functions | |||
VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
vlookup from multiple columns | Excel Worksheet Functions |