VLOOKUP using two criteria

[DC_C2C]

Is there a way to use a VLOOKUP formula that looks at two criteria to return avalue?

I have data from a Microsoft Form in a row from A:O which includes a name, month and a series of scores. From a dashboard page on another sheet, I can select my name from a dropdown and use a VLOOKUP to query the table and return certain values from columns I:O. The formula runs on another six lines each looking at a different Column on Sheet 1. This works as expected using the formula below (cell B4 is my name)

=IFNA(VLOOKUP(B4,Sheet1!A:O,9,FALSE),"Not Found")

The issue comes that next month a new line of data is created that has my name, a different month and a different set of scores. I need to display the values from this month on the dashboard. Ideally, I select my name from cell B4 and text from cell B5 “May 2024” and have it display the data from the columns of the row that matches it.

The dashboard will have two sections both showing the same data but with different periods shown, top section May 2024, lower section June 2024.

Is this possible with a VLOOKUP?

Cheers

 

[etaf]

is month column B

=Index($I:$I , match( B4&B5, $A:$A&$B:$B,0))

just change the I to the column you want to return

also the formatting is it a real DATE
or just text

 

[DC_C2C]

Thank for the response.
On the Microsoft Form data sheet my name is Col G, the date is Col H and the other data are Cols are I:O

The date is text field and not a real date

 

[etaf]

=Index($I:$I , match( B4&B5, $G:$G&$H:$H,0))
BUT
if the date is TEXT in both sheets , then should be OK
so TEXT
MAY 2024
but if one is a real date , then it wont
SO B4 and B5 are joined together
JOHN BLOGGSMAY 24
and the columns would be joined together
JOHN BLOGGSJAN 24
JOHN BLOGGSFEB 24
JOHN BLOGGSMAY 24 - so this will match and return the value in I

=Index($J:$J , match( B4&B5, $G:$G&$H:$H,0))
returns J

shown here

Book4
	A	B	C	D	E	F	G	H	I
1
2
3
4		John Bloggs	this is the row
5		may 24					J blog	Jan 2024
6							B blog	Jan 2025
7							John Bloggs	Jan 2026
8							J blog	May 24
9							B blog	May 24
10							John Bloggs	May 24	this is the row
11
Sheet1

Cell Formulas
Range	Formula
C4	C4	=INDEX($I:$I, MATCH( B4&B5, $G:$G&$H:$H,0))