Find Value in index and return adjacent cell

[t2tommy]

I am in desperate need of assistance with a formula, I have looked through similar posts to try and solve my problem but none are working the way I need it to.

I have a list of values in A and B (B won't matter for formula just a related value to A, A may have same value duplicated with different B)... I also have a list of the same type of values that are in A in E and a related value to E in F. I need C to return a value of the F column next to the matching A and E column.

I have attached a sample of what I'm trying to do.

[Jonmo1]

Try this in C2 and filled down

=INDEX($F$2:$F$50,MATCH(A2,$E$2:$E$50,0))

[AndyLitch]

Put this formula in C2
=IF(A2=E2,F2,"")
and paste it through the table

Disregard mine ...It's rubbish

[t2tommy]

Try this in C2 and filled down

=INDEX($F$2:$F$50,MATCH(A2,$E$2:$E$50,0))

Thanks for the prompt reply. That didn't work, I am getting different result in C for the same A cells... Example, A6-12 are the same but have C results of 2,3, and 4.

[t2tommy]

Put this formula in C2
=IF(A2=E2,F2,"")
and paste it through the table

Disregard mine ...It's rubbish

That one only works if they match up line for line which the A list is much longer because A could be duplicated with a different B but should get the same F. Thanks though.

[Jonmo1]

Thanks for the prompt reply. That didn't work, I am getting different result in C for the same A cells... Example, A6-12 are the same but have C results of 2,3, and 4.

I don't know, works for me.
Book2(1).xlsx

Can you repost the book while it is returning those incorrect results?

[t2tommy]

I don't know, works for me.

Can you repost the book while it is returning those incorrect results?

You're amazing! I dont know what it was but I reopened and tried again and it worked that time! Thank you so much!

[Jonmo1]

Great, glad to help.

[mehmetcik]

This seems to work.

Please Login or Register  to view this content.