I have got a data file. A sample of the data is attached for convenience. Column A contains the name of the books in varioys rows, while column B, C & D contains the qty of the respective books in the given racks.
I want to search by book name likewise :
Qty of Book 1 in Rack1 = 10. Similarly if I want to search for Book2 in Rack3, what should be the formula for it. I have to use a combination of INDEX & MATCH function but somewhoe not able to get it correct.
Thanking in advance as always...
Last edited by srinivas_kaship; 06-09-2009 at 01:18 AM.
=INDEX(B3:D7,MATCH(G4,A3:A7),MATCH(G5,B2:D2))
Where G4 is the book
and g5 is the rack
Last edited by squiggler47; 06-08-2009 at 07:49 AM.
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Thanks a lot. I understood the concept of using Index & Match very clearly from your solution....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks