Lookup???

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
 
D

DRod

That's actually what I have. Sorry...I pasted the
incorrect formula. And, that still does not work properly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Vlookup to reference offset 1
formula referring to a worksheet 4
VLOOKUP 1
HELP!!!!!!!!! 2
delete duplicates 0
Avoiding redundant calculations 7
Automatically populating cells down a row 8

Top