Hello. My question is: I have two tables ah the same sheet, below:
A B
1
2
4
6
7
.........
G H
1 1.1
2 0.6
3 0.8
4 1.2
5 1.7
6 0.9
.........
I want to do this: in column A, where the value of the first cell is "4", I want to search for this value in the whole column G and, if found, return the value of the column H (in this case, 1.2) and put into a formula in column B. How can I do this?
Thanks for the attention.
Bookmarks