View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default vlookup with multiple columns

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