Sheet is on the cloud, and being used by people with Google Sheets, so VBA is out unfortunately.

Trying to get a vlookup to check 'Monday!A3' with 'Weekly Roster!E:E', but it also has to match 'Monday!E1' with 'Weekly Roster!G:G' and then returned 'Weekly Roster!H'

If this was VBA I'd be able to smash it out, but unfortunately its not!

Have tried numerous different ways, and they don't work! Here are some below examples;

```
=AND(VLOOKUP(E1,'Weekly Roster'!A:M,8,FALSE),VLOOKUP(A3,'Weekly Roster'!A:M,8,FALSE))
=VLOOKUP(A3, IF(E1='Weekly Roster'!G:G,'Weekly Roster'!H:H,""), 8, FALSE)

```

(And some others that have been deleted!)

If someone could point me in the right direction that'd be fantastic! Appreciate the help!

Sheet = Monday -> Matching 'Monday!A3' to 'Weekly Roster!E:E' and then also matching 'Monday!E1' to 'Weekly Roster!G:G' and returning 'Weekly Roster!H'

Monday Sheet:
[![Monday Sheet](https://i.stack.imgur.com/grXTZ.png)](https://i.stack.imgur.com/grXTZ.png)

Weekly Roster:
[![Weekly Roster](https://i.stack.imgur.com/7Dj76.png)](https://i.stack.imgur.com/7Dj76.png)