Vlookup/Match for multiple criteria across worksheets

[SnKeaK]

https://1drv.ms/x/c/f7b9915682722e86/EQa4FmNLK7xEnVexYmVntocBYp6VwJ4k4Qq9uN7YmhIJNQ?e=e6HiSh

1. Daily I export data from a website and import the data into an excel worksheet titled "GoatedWagerCSVs". Everyday I'll import that days data underneath the dated cell the data corresponds to.
2. Once, Imported; in the "Goated Wager Analysis" worksheet, my objective is to for example, in B3, write a formula the searches "GoatedWagerCSVs" worksheet for the date that matches the adjacent cell, which is A3 in this scenario. And once it matches the proper date, use the data underneath in THAT table.

So in summary, in "Goated Wager Analysis", formula for B3 to look at A3, match it to the appropriate Table in "GoatedWagerCSVs", then takes B1 and matches it to the name in that days data, and then returns the value of the adjacent cell for Wagered, which is Column D, value 45

 

[SnKeaK]

I'll try to be more clear, as my initial question/explanation may have been confusing.

As seen in the attached images, I am trying to get the result of "45" in B3 of the first worksheet by searching in another worksheet for the correct data, based on Date and Username.

The things needed are as follows.

1. Search worksheet B in Row 1 for the date that matches Worksheet A's A3 = 11/18/2024
2. Now that we located the date's location in Worksheet B, Now we use the data in that days table.
3. In Worksheet A, B1 = "Aisha". Now I need find "Aisha" in the "11/18/2024" data table from Worksheet B, and return the value to the right 3 cells over. Which would be in the "Wagered" column "45".

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also will all the table names be in the format of goated_stats_11_18_24?

 

[SnKeaK]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also will all the table names be in the format of goated_stats_11_18_24?

Updated those, thanks. And yes. Every new csv file will be imported to the right, same format, same number of columns, but new users will show up by the day, causing row data/length to be different. Which shouldn't be a concern since I am trying to search the entire column range for a specific name.

 

[Fluff]

Updated those

Thanks for that.
How about

=VLOOKUP(B$1,INDIRECT("goated_stats_"&TEXT($A3,"mm\_dd\_yy")),4,0)

 

[SnKeaK]

Thanks for that.
How about

=VLOOKUP(B$1,INDIRECT("goated_stats_"&TEXT($A3,"mm\_dd\_yy")),4,0)[/CO
[/QUOTE]

This is perfect! I usually understand what's going on after seeing the formula written out, but this time i'm lost. haha. The portion where you have "goated_stats_"&TEXT, what's happening here? Will I have to name a range every time I upload the daily csv files or does this formula just know to look for it as is?

Thank you so much!

 

[Fluff]

As long as the tables are all named in the format "goated_stats_mm_dd_yy", then the formula will work.

 

[SnKeaK]

As long as the tables are all named in the format "goated_stats_mm_dd_yy", then the formula will work.

Good to know. Thank you So much.

 

[Fluff]

You're welcome & thanks for the feedback.