INDEX MATCH HELL ooops.. I mean HELP!

  • Thread starter Thread starter radlee
  • Start date Start date
R

radlee

I know (or at least I think I do) that I can do this with INDEX
MATCH. Here is what I want to do. I want to place this formula in
cell C4 of Sheet 1. What I want this formula to do is to match the
value of B2 of Sheet 1 with a list that is in Sheet 2 found in
C3:C24566. Once it matches these two values, i want it to return the
corresponding text in D2:D24566. I am pulling my hair out. Any
advice would be appreciated!!!

Thanks!
Lee
 
Assume datalist is on Sheet2, from C2 to D24566.

=INDEX(Sheet2!D2:D24566,MATCH(B2,Sheet2!C2:C24566,0))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I know (or at least I think I do) that I can do this with INDEX
MATCH. Here is what I want to do. I want to place this formula in
cell C4 of Sheet 1. What I want this formula to do is to match the
value of B2 of Sheet 1 with a list that is in Sheet 2 found in
C3:C24566. Once it matches these two values, i want it to return the
corresponding text in D2:D24566. I am pulling my hair out. Any
advice would be appreciated!!!

Thanks!
Lee
 
Hi,

As described you might be able to use either VLOOKUP or LOOKUP instead of
MATCH and INDEX:

=VLOOKUP(B2,Sheet2!C3:D24566,2,False)


If this helps please click the Yes button.
 
Back
Top