Hello,
I asked for help last time and you guys were super helpful
I have trouble with excel again and the solution seems very simple yet I can't figure it out. I tried to use arrays and all kinds of stuff from the excel help file but to no avail.
It would take forever to describe the problem so I just made a sample Excel file.
If anyone has any ideas, please feel free to share.
I have excel 2003 and the file is attached.
Thanks a lot
Last edited by liquidicy; 09-01-2009 at 07:28 PM.
in I29
=LOOKUP(I19,$C$4:$C$42,$D$4:$D$42)
dragged down and across
"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: Input table -> Output table
Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks