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
an array formula, so commit with Ctrl-Shift-Enter=INDEX('ON HAND'!E:E,MATCH(A3&B3,'ON HAND'!A1:A1000&'ON HAND'!B1:B1000,0))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
xld -
Simply put - outsanding!
Thanks,
Kurt
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!
I thought it meant playing in the sand-pit.Originally Posted by geekgirlau
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!
Can't do yours when the paint is peeling on mine.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
