LinkBack URL
About LinkBacks
pigment01 
This in D2 on the master sheet should work for you:
=INDEX(List!$A$1:$A$623,MATCH(1,INDEX((List!$B$1:$B$623=Master!A2)*(List!$C$1:$C$623=Master!B2),0),0))
This in D2 on the master sheet should work for you:
=INDEX(List!$A$1:$A$623,MATCH(1,INDEX((List!$B$1:$B$623=Master!A2)*(List!$C$1:$C$623=Master!B2),0),0))
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
Can you please walk me through your formula and logic? I have never used INDEX and MATCH functions before :pOriginally Posted by nigelbloomy
This in D2 on the master sheet should work for you:
=INDEX(List!$A$1:$A$623,MATCH(1,INDEX((List!$B$1:$B$623=Master!A2)*(List!$C$1:$C$623=Master!B2),0),0))
Also for some values I am getting N/A I guess it might be because some of the event values don't match up fully
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks