VLOOKUP problem from multiple sheets

[boydcarter]

On an Open sheet where the remaining sheets are named sheet2 and sheet3. I entered in d2, a general-formatted cell: =VLOOKUP(c2,’*’!a:b,2,0). The formula was accepted and excel converted the formula to =VLOOKUP(C2,Sheet2:Sheet3!A:B,2,0) and returned an error code of #VALUE. (Col c on this sheet is formatted for text.) If I “step in” when the evaluation underlines c2, I get the message: The cell currently being evaluated contains a constant. This was addressed at: http://www.excelforum.com/excel-work...-constant.html but didn’t solve my problem. I’ve attached a file representing the problem. I’ve struggled with this over a day, visiting many forums where the question seems to be answered, to no avail. Can anyone tell me what I’m doing wrong? Thanks. Boyd Carter