I want to put a given value (Cost) in a given position in an array (years 2017-2023) based on a third cell (Cost Yr).. I know (suspect) that a Index Match combo is the way to go but am struggling to get it to work, and I know it's a simple solution, but can't seem to do it and suspect that perhaps an alternative formula is needed.
Excel Problem.JPG
you can just use an IF
=IF($A3=C$2,$B3,"")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
In B3 (double comma intentional):
=INDEX($C$3:$I$4,,MATCH(A3,$C$2:$I$2,0))
Copy down.
EDIT: Sorry, misread the requirement. Etaf's answer is correct.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
OMG... I've got so involved with INDEX MATCH that I forgot the logical and simplest solution... thanks for bringing me back to earth.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks