Formula to Find Matching Data
 

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 Id 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 its 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.

Formula to Find Matching Data
 

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

adapt to fit to your own cell references


--


Regards,


Peo Sjoblom


"NM" wrote in message
...
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.

Formula to Find Matching Data
 

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

This worked perfectly.

Thank you for your time and assistance.

"Peo Sjoblom" wrote:

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

adapt to fit to your own cell references


--


Regards,


Peo Sjoblom


"NM" wrote in message
...
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.