1

I am trying to return the points rank value when both B2 on Player lookup and C2 on Player Lookup match the DvP dataset which i highlighted in the sheet.

So for example: For Lebron James I'd like to return the value from cell N89 based upon the previously mentioned cells (C2 and B2)

https://docs.google.com/spreadsheets/d/15-NCFTXPCypCSm6EBaFqDG5Bsib1hwb29ck2Yiaq7EA/edit#gid=1377910615

Formula I tried =INDEX(DvP!L4:T,MATCH(C2,DvP!M4:M,0),MATCH(B2,DvP!L4:L,0))

player0
  • 124,011
  • 12
  • 67
  • 124
TooTallDerr
  • 95
  • 5

1 Answers1

2

use:

=INDEX(VLOOKUP(TRIM(B2&C2), {TRIM(DvP!L:L&DvP!M:M), DvP!N:N}, 2, 0))

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
  • Thanks, its giving me an "Did not find value 'SFLakers' in VLOOKUP evaluation." error – TooTallDerr Nov 25 '22 at 01:41
  • @TooTallDerr that is reasonable as because there is no `Lakers` in `DvP!M:M` range. if you want the result you wish for then `C2` needs to read `LAL` or `Lakers` would need to be located in `DvP!M89` – player0 Nov 25 '22 at 02:12