Hi,
I am wondering whether it is possible for someone to take a look at the attached spreadsheet and advise on a formula to automatically populate a range of cells based on the value in another cell. I have added notes on the spreadsheet if someone is able to take a look.
Many thanks in advance.
AndyTreadmill Speeds Example for Excel Forum.xlsx
How about:
Cheers,
=INDEX($S$16:$W$22,ROW(S16)-ROW($S$15),MATCH($B$32,$S$15:$W$15,0))
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
WE5T 
Register To Reply
Bookmarks