coloumn A to column B value

Occasional Visitor

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=$A$22. What is the formula to extract value corresponding to B22?

Please find attached file.


Kindly help.



1 Reply

@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.