MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Dave on July 25, 2001 8:15 AM

I have two cells that lookup a value in one cell and pull information from two other tabs within the workbook, but only one of the instances will return a value, the other comes up #n/a.

Posted by Aladin Akyurek on July 25, 2001 8:17 AM


I suppose you don't want see #N/A's. Could you post your VLOOKUP formula "as is"?


Posted by Mark W. on July 25, 2001 8:18 AM

Let's have a look at the formulas.