lookup formula's

N

Neuther

=vlookup(((vlookup((vlookup(Lookup!X387:Y393,2,false)Main!A2:F7,6,false)B465:L500,3,false)))

i know it's wrong cause it won't let me do it but i just don't kno
what's wrong w/ it.

Can someone pleas hel
 
B

Biff

Hi!
what's wrong w/ it.
Click to expand...

Well, the main problem is that you don't have a lookup
value for any of the vlookup functions. You have to tell
the lookup function what to lookup!

Here's how you formula breaks down:

vlookup(_______,Lookup!X387:Y393,2,false)- no lookup value

vlookup(_______,Main!A2:F7,6,false)- no lookup value

vlookup(_______,B465:L500,3,false) - no lookup value

What exactly are you trying to do?

Biff
 
Top