PDA

View Full Version : Double Lookup Formula



stapuff
09-22-2005, 11:28 AM
On sheet1 P3 I would like the result of this formula:

vlookup A3 against sheet2 A:A, once found vlookup B3 against B:B,and give me the offset 5 value.

=VLOOKUP(A3,INDEX('ON HAND'!A:A,MATCH(B3,'ON HAND'!B:B,0)):E10000,5)

This is not giving me the result I am looking for. Any idea's?

Kurt

xld
09-22-2005, 11:34 AM
=INDEX('ON HAND'!E:E,MATCH(A3&B3,'ON HAND'!A1:A1000&'ON HAND'!B1:B1000,0))

an array formula, so commit with Ctrl-Shift-Enter

stapuff
09-22-2005, 11:49 AM
xld -

Simply put - outsanding!

Thanks,

Kurt

geekgirlau
09-22-2005, 04:29 PM
Kurt, don't forget to mark this post as "Solved".

xld - if you're "out sanding" I've got lots of work for you round at my place! :tongue2:

xld
09-22-2005, 04:40 PM
Kurt, don't forget to mark this post as "Solved".

xld - if you're "out sanding" I've got lots of work for you round at my place! :tongue2:

I thought it meant playing in the sand-pit.

Can't do yours when the paint is peeling on mine.