Hi,
I am having difficulty getting a formula to extract a value from two different ranges. My data can only be pulled this way. Here is hat I am trying to do. I have named two ranges. Week (Column A to D) and Tech (column G to J) Each Column represents a week out of 4 weeks. In another sheet I have one value (Week number- column B). What I want the formula to lookup if A is "On-Call" and then lookup up B and search every name in my 'Tech" range that matches the week number from range "Week". It is difficult to explain. I have attached a spreadsheet. The formula result I want is in column F. (I hightlighted in sheet Data the cells I want the results from.) Let me know if you need more info.
Thank you
Bookmarks