Hello,
I have a reference worksheet that contains many entries. Here is a snippet:
1.2 1.0047 1.21 3.11
1.25 1.0049 1.26 3.24
1.3 1.005 1.31 3.37
1.35 1.0052 1.36 3.5
For example, I want to use a variable (ex: var1 = 1.25) from one worksheet and have the value found in on my reference worksheet. Such that I want to use var1 (1.25) and return 1.26 (3rd value on the 1.25 line).
What is the most efficient way to do this?
Thanks in advance.
Bookmarks