Forum Discussion

pisemt's avatar
pisemt
Copper Contributor
Mar 18, 2021

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

Please find attached file.

 

Kindly help.

Thanks 

Mangesh

excel

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 18, 2021

    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.

Resources