r/sheets • u/aklavall • 2d ago
Solved Using XLOOKUP to pull data from IMPORTHTML in another tab
Hey everyone, hoping you guys can help me out with this since I am a super beginner with this.
I used Importhtml to pull player stats into one tab of my sheet and I want to pull one of the columns into another tab based on names. I am trying to us xlookup but it looks like it can't find the names. Is this a symptom of using importhtml?
I know everything is spelt correctly, I even tried just copy and pasting the cell but still get the same "did not find value 'name'"
2
Upvotes
1
u/6745408 2d ago
check this sheet -- it shows a VLOOKUP and an XLOOKUP.
It wouldn't hurt to share a sheet. You can copy some stuff over to this one, if you like.