Convert cell location to cell contents

[Private]

My question is part of a complex formula.

What I want to do is find the product of E3*A3 (sheet2).

The issue is that E3 contains a complex formula that results in the cell location of the cell to the left of the cell which matches my search reference.

This is the equation in E3: =ADDRESS(MATCH(B3,Sheet1!A:A,0), 2,4)

How can I get E3 to be converted to the content of the cell location (sheet1) found in E3 so that I can multiply that number by A3?

Do you have any ideas? The result of my formula will be that I can automatically cost recipes as I am writing them by referencing sheet1.

 

[steve the fish]

Hi. Try:

=VLOOKUP(B3,Sheet1!A:B,2,0)

 

[Private]

Thank you so much, that did the trick!