Mar 18 2021 12:32 AM
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.
Thanks
Mangesh
Mar 18 2021 12:49 AM
@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.