Hello,
I have been struggling to find an formula that will prevent me from having to manually input the table array using VLOOKUP.
In the past my formula was
=IFERROR(VLOOKUP(A3,Games!$A$5:$C$16,2,0),IFERROR(VLOOKUP(A3,Games!$D$5:$F$16,2,0),"N/a"))
Screen Shot 2020-12-09 at 3.57.24 PM.png
And I would be grabbing the data from here
Screen Shot 2020-12-09 at 3.59.29 PM.png
Rather than having to individually do this formula for every game played I was hoping there was a formula I can use to just drag it across the sheet for every game 1-100.
I tried doing
=IFERROR(VLOOKUP(A3,OFFSET(MATCH(E2,Games!$A$3:$F$49,0),2,0,12,3),2,0),IFERROR(VLOOKUP(A3,OFFSET(MATCH(E2,Games!$A$3:$F$49,0),2,3,12,3),2,0),"N/a"))
My thoughts were that this would pick Game 1, find it in the array, and then perform the offset function for the table underneath it, and then follow up by performing the Vlookup I need to grab the value for the chosen player, but the formula gives me an error so any suggestions would be great, thanks!
Bookmarks