Hi,
I'm trying to make index+match function work for me, but I have hit the wall. How to match the date but return the value from 3 collumns to the right? Could someone please give me a syntax of the formula at least?
Thanks
Hi,
I'm trying to make index+match function work for me, but I have hit the wall. How to match the date but return the value from 3 collumns to the right? Could someone please give me a syntax of the formula at least?
Thanks
ad3=INDEX($B$5:$Y$21,MATCH(AC5,$A$5:$A$210,0),MATCH($AD$3,$B$3:$Y$3,0))
ag3 =INDEX($B$5:$Y$21,MATCH(AF5,$A$5:$A$210,0),MATCH($AG$3,$B$3:$Y$3,0)+2)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hm.. That was simple. I thought the COLUMN function would be needed here, but it seems not. Works just perfect! Thanks mate!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks