Formula to Find Matching Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm thinking a lookup type function would work for what I need, but I'm not
too familiar with that function, and what I tried didn't work. Any help
would be appreciated.

I have values in column C that I’d like to find in column B, then copy the
data from column A in that corresponding row, and update column D with the
data from column A.

To clarify. . .

For example: In row one I have ‘123’ in column C. I want to find ‘123’ in
column B -- say it’s found in row two -- then copy the data from column A in
row two and paste it into column D in row one, where the formula originated.

Can this be accomplished?

Thank you.
 
=INDEX(A2:A100,MATCH(C1,B2:B100,0))

adapt to fit to your own cell references


--


Regards,


Peo Sjoblom
 
Ah, INDEX. No wonder lookup commands didn't work. :-p

This worked perfectly.

Thank you for your time and assistance.
 
Back
Top