Multiple conditions to get data
Hello,
I need a formula to get data based on 2 conditions. One condition is date and another is a lookup value. I have attached a spreadsheet with my requirement. Can you please look into it and advise how can I get the required data.
Regards,
Mandeep
Hi mrd4u and welcome to the forum,
Put this in B2 and Pull Down
=INDEX(Data!$C$2:$G$14,MATCH(B$1,Data!$B$2:$B$14,0),MATCH($A2,Data!$C$1:$G$1,0))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
fabulous...thats gr8
thanks a lot.....it solved my issue
This worked for me in your example.
=HLOOKUP($A2,Data!$C$1:$G$14,MATCH(Route_Details!$B$1,Data!$B$1:$B$14,0),FALSE)
Alan
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks