Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there,
I have another question/problem which involves vlookup. It's similar to my last one, but with a little twist. I have 18 Groups listed in Column F In Columns G to R 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 C3 to lookup the number in A3 (Column A lists a single number between 0-40) and compare it to the numbers associated with the group listed in in B2. If the number in A3 is found in the group of numbers associated with the group in B2 then "Match" is given in C3, if not "Miss". A quick example: B2 contains Group F (1,2,4,5,7,10,11,17,24,26,30,38) A3 = 26 I would like C3 to compare the number in A3 (26) to Group F (cell B2) and tell me if the number (26) is present in the group (it is in this case). If it is, I want a "MATCH" in C3. Thanks a bunch! Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
Vlookup Question | Excel Worksheet Functions | |||
VLOOKUP question | Excel Worksheet Functions | |||
=vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP Question | Excel Worksheet Functions |