Mike Langlois
Member
Hi all,
I am trying to use two HLookups to find data in a table based on two criteria. I am setting up a series of front sheets to read my data, and need a a formulae that will do a hlookup on the date, then hlookup on the team, and then look down to find the relevant number.
As an example I have included an example spreadsheet. On Sheet 1, I would like C3 to show the Total Incoming from Sheet 2 for Team 3. I have set up my front sheet to include a drop down box that changes the dates in C2 to F2 to the chosen week. So C3 would need to search for the date that is chosen, then choose the correct team, and then find the relevant number.
I feel this may be achievable with two H Lookups, or maybe an Index Match Match?
I am trying to use two HLookups to find data in a table based on two criteria. I am setting up a series of front sheets to read my data, and need a a formulae that will do a hlookup on the date, then hlookup on the team, and then look down to find the relevant number.
As an example I have included an example spreadsheet. On Sheet 1, I would like C3 to show the Total Incoming from Sheet 2 for Team 3. I have set up my front sheet to include a drop down box that changes the dates in C2 to F2 to the chosen week. So C3 would need to search for the date that is chosen, then choose the correct team, and then find the relevant number.
I feel this may be achievable with two H Lookups, or maybe an Index Match Match?