Hello,
Please see the attached spread sheet. Basically I need S21 to lookup the price based on S17 and S18. Any help is most appreciated! Thank you.
Hello,
Please see the attached spread sheet. Basically I need S21 to lookup the price based on S17 and S18. Any help is most appreciated! Thank you.
change j13:m13 to 1,5,10,15,20
then use in s20
=INDEX(J15:N22,MATCH(S17,A15:A22,0),MATCH(S18,J13:N13,1))
"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
Perfec!! Thank you Martin!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks