Function IF - Macro

Good afternoon,

I'm new here and I need some help.

I need to make a workbook, where I believe I need a Macro, but do not know how to do well.

The idea is as follows:

Have a value in cell F19 (RDS123), this figure varies, as this linked with another tab.
What do I need to do, is to compare the F19 cell with E21 to E32 .... if F19 = E21, the value that appears in cell H21, should appear in the cell H19, if not, have to compare F19 = E22 ... and so forth, and place .... H22 in H19 cell.

Someone can give me a hand?

thank you

Hi. It sounds like this is what you need:

=INDEX($H$21:$H$32,MATCH(F19,$E$21:$E$32,0))

If not, please attach an Excel sheet showing your requirments.

Great! I'm glad to have helped! If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

I see that you have amended your first post at 18:23 UK time. Does this change affect the solution provided?