Macro to Change Cell Text

[erock24]

I have a table called "HydroTable". It consists of 2 rows and 2 columns.
text in 1st column and value in 2nd column. I need a macro to match the values in J6 & K6 to the values in the table and replace J6 & K6 with the matching text. Is this possible?

Thank you.

[erock24]

Well, I just named the ranges and through it into an if statement. I'm sure there is a more elegant way but I think this will work:

Please Login or Register  to view this content.