Hi all,
I think this should be fairly simple to formulate, but I'm struggling with it myself. I need to retrieve cell data based on two criteria but am having trouble as the second criteria needs to be retrieved only from a range that depends on the first criteria. I have three columns; Employee name, Month and Wages. I need a formula that returns the correct cell value from column 3 when I select Employee name and Month from two drop down menus. Attached is an example file.
Many thanks!
Hi,
Perhaps:
=INDEX(C:C,MATCH(A46,A:A,0)+TEXT(1&B46&2013,"m")-1)
Regards
Please see attached file.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Re: Vlookup based on multiple criteria problem
XOR LX and AlKey, thanks very much for your help!
Both work great, but I would probably favour XOR LX's formula as to avoid necessitating putting a value in the name column on each row.
XOR LX:- how does your formula know to pick up the correct month as the example shows 3 'Januarys' etc.
Great stuff, thanks
You're welcome.
The formula works by first searching for the position of the desired name and then offsetting that position downwards based on the month.
I have to say that it's not a very flexible approach (it depends on your months being in order, for example) so, if you're going to be extending this, it's likely that an approach similar to that offered by AlKey would be preferable.
Regards
XOR LX, still I must say it was a very interesting and elegant approach!Originally Posted by XOR LX
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks