Lookup???

  • Thread starter Thread starter Ashish Mathur
  • Start date Start date
A

Ashish Mathur

Hi,

The formula for the vlookup formula should be

VLOOKUP(A1,Sheet1!A1:Z100,26,FALSE). The range should be
Sheet1!A1:Z100 and not Sheet1!A1:A100

Hope this works

Regards,

Ashish Mathur
Excel - MVP
 
That's actually what I have. Sorry...I pasted the
incorrect formula. And, that still does not work properly.
 
Back
Top