On 2002-04-07 12:44, gumby wrote:
I have this =VLOOKUP(B17,$A$40:$B$49,2,FALSE) in my sheet. cell b17 has "=a43".(I'm assuming this is the problem) It gives me the error #N/A. how can I format the b17 cell reference in vlookup so it will see it as a cell reference and not text.
On 2002-04-07 14:13, gumby wrote:
cell a43 contains text "chaintech excel"
I want vlookup to look in cell b17 which has "=a43" then return the data in cell b43
On 2002-04-07 14:52, gumby wrote:
no, the entry in b17 does not have quotes
b17 contains =a43