yogi_Pull Hours data from Column G of spreadsheet 'Schedule' matching it with 'Date' 'Provider' 'Start Time' and 'Start Location

Google Spreadsheet   Post  #2558

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-31-2018

question by: NJP2017:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/LJDMT51jGWY;context-place=mydiscussions
Can I do a multi paramater index match with one parameter searching a range of values?

I'm not sure if what I am trying to do is even possible but I thought I would bring it here in case anyone can help. I an working with two different Google Sheets documents. One is Audit (https://docs.google.com/spreadsheets/d/1VCuhiYd01pgQKYWWTbXo5mYxW4wsFGe66Wf9jN8O4ng/edit#gid=0) and the other is Schedule (https://docs.google.com/spreadsheets/d/1p65lN0FzxrscEAAEmb_Ohga-XgMSSWXirts5UI1LgRU/edit#gid=0).

I am trying to pull the hours data from the Schedule doc (column G) and match it with the date, provider, start time and start location. However, the start location names aren't consistent so I have the alternate names on the Start Location tab of the Audit sheet. I was trying to just do the range part using another help page (https://stackoverflow.com/questions/14803944/excel-searching-for-multiple-terms-in-a-cell) but I couldn't even get that part to work.

Is there a way to do this or a better method anyone would suggest without altering the data (which I can't on the actual documents).