Forum Discussion
coloumn A to column B value
I have column A and B with some values. I want to extract specific value from column B corresponding to column A. For example A22=1000, how to extract value corresponding to B22? The address for A22=...
pisemt In your example, I fail to see the logic of why the x value in row 145 should be paired with a y value from row 166. In case it is your intention to pair x and y from the same row, based on the reference value in C, you can use a regular INDEX / MATCH formula. No need for CELL and INDIRECT.
See attached.