• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Looking up a value based upon two variables

S

Shoebird

Member
I am trying to find a value based upon a couple of variables contained within a different workbook.

The first layer of filtering would be based upon site.

The second layer would be based upon room within the site.

The last would be based upon location within the room of the site.


Not sure if match is my best approach but any suggestions would be great.


Thanks in advance.
 
I'd recommend starting with this article:

http://chandoo.org/wp/2010/11/02/multi-condition-lookup/
 
I will give the information in the link a try and report back if it worked or not. Thank you very much Faseeh and Luke M for your replies.
 
You must log in or register to reply here.
Back
Top