LinkBack URL
About LinkBacks
Hi I want to extract size information from j3 to U3 cells into i3 cells for corresponding year. The year should be matched from c column and j1 to u1.
Hi I want to extract size information from j3 to U3 cells into i3 cells for corresponding year. The year should be matched from c column and j1 to u1.
there is no year 2000 in that table oops yes there is
otherwise
=LOOKUP(C2,$J$1:$U$1,J2:U2) would work. fyi numbers in j1:u1 are text re enter them as numbers
Last edited by martindwilson; 11-24-2012 at 09:19 AM.
"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
Re: look up values
Hi,
U can use index and match to get your answer.
e.g
=+INDEX($J$1:$U$7,ROW(),MATCH(C2,$J$1:$U$1,0))
Pl find the attached file.
Thanks
Ranjeet.
In I2, Drag Down
Formula:
Please Login or Register to view this content.
Note
I would be tempted to change $J$1:$U$1 to numbers and then use
Formula:Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Hi mahershams
Are we looking at matching C2! If so try in I2 and copy down:
Formula:Please Login or Register to view this content.
Array formula, CTRL + SHIFT + ENTER, not ENTER
Last edited by Kevin UK; 11-24-2012 at 08:38 AM.
@ Ranjeet.
Why restrict the reference range?
@ Kevin
Why use an array formula, when it is easier to write a standard equivalent? ...
Hi Marcol,
I agree with U.
thanks.
for that matter
=INDEX($J2:$U2,,MATCH($C2&"",$J$1:$U$1,0))
or
=LOOKUP(C2&"",$J$1:$U$1,J2:U2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks