hello All
Driver Scores Tab
where there is a zero - the formula isnt working,
it needs to look up Daniel Ricciardo from Drivers Scores, but on the we data tab its D. RICCIARDO
please see attahed
Paul
hello All
Driver Scores Tab
where there is a zero - the formula isnt working,
it needs to look up Daniel Ricciardo from Drivers Scores, but on the we data tab its D. RICCIARDO
please see attahed
Paul
Rather than using SUMIF you could get the results with an INDEX/MATCH lookup.
Try this in D3 then copied down and across as required:
Formula:Please Login or Register to view this content.
BSB
Try this instead:
=INDEX('WEB Data'!C:C,MATCH(LEFT($A3)&". "&MID($A3,FIND(" ",$A3)+1,LEN($A3)),'WEB Data'!$B:$B,0))
No need for CTRL+SHIFT+ENTER.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The problem is with the data on the web page, not your formula ... although it doesn't need to be an Array Formula.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry, I should have said: I used a small VBA routine to ensure that the data was numeric. I'm not sure why it wasn't being treated as such. One of the hazards of using web data, I guess. I also changed the formulae to normall formula (not Array Entered).
The formula is working fine, the web data has a formatting issue which is causing the error.
You could fix it by copying an empty cell then applying pastespecial - add to web data C2:W24,or more simply use INDEX as BSB has already suggested.
As you have structured tables,
Formula:Please Login or Register to view this content.
Note that the formula is broken into 2 lines deliberately, I'm not sure why, but table references with spaces in the column name don't work without this.
thanks All for your time and effort
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks