Hi guys, I am having a little trouble here...

My problem is that the lookup value on my formula (C1) contains a formula, so vlookup return N/A. I want vlookup to use the value in the lookuo value and not the formula in cell.

Any help?

Cell C1 formula (=Settings!d17) Cell C1 value (3)

I need to use the 3 as the lookup value not =Settings!d17

Please help

Edit: Solved please close
cotufa-ssdd Reviewed by cotufa-ssdd on . vlookup help Hi guys, I am having a little trouble here... My problem is that the lookup value on my formula (C1) contains a formula, so vlookup return N/A. I want vlookup to use the value in the lookuo value and not the formula in cell. Any help? Cell C1 formula (=Settings!d17) Cell C1 value (3) I need to use the 3 as the lookup value not =Settings!d17 Rating: 5