Log In
Register
Home
May 5, 2021
Offline
I have tried to add a Vlookup to the attach worksheet DashBoard_team_Player, I have been able to do some Vlookup from some worksheet but have not been able to do in the DashBoard_team_Player, in cell L32 referring to worksheet fact_player_technical
See Answer
July 16, 2010
Online
Hi Andrew,
VLOOKUP is looking up column A of the fact_player_technical sheet for the date in column K and value in column L of the Dashboard_team_Player sheet, but column A of the fact_player_technical sheet only contains a date, therefore you can't use VLOOKUP in this way.
Instead, use INDEX & MATCH like this:
=INDEX(Table1[tackles_attempted],MATCH(DashBoard_team_Player!K30&DashBoard_team_Player!L30,Table1[fixture_date]&Table1[player_master_id],0))
Mynda
Answers Post
May 5, 2021
Offline
Hi Mynda
Thats is that the case for all tables? should the date be placed in another column?
Cheers
Andrew
July 16, 2010
Online
Not sure what you mean by 'should the date be placed in another column'. Do you mean in the lookup array or the lookup value?
May 5, 2021
Offline
Hi Mynda
Sorry to ask so many questions, as I get the Vlookup to work in one cell and not the next. In the fact_player_technical w/sheet A is the date followed by 32 other columns, should the data have been moved to another column or is it down to the function I'm using as, I'm appearing to be getting error which I do not encounter with my other Vlookup's?
I have tried to get a match with player_master_ID and master_name but now that is giving n/a?
Cheers
Andrew
1 Guest(s)
