I want a lookup that, instead of returning just one value as per usual, I want it to return the result it would usually find AND the 19 cells below it as well. I want all these values to appear in a dropdown list in the cell where I enter the vlookup. Possible?
to get a cell 19 cells below
index(c1:c1000,match(a1,b1:b1000,0))
and
index(c1:c1000,match(a1,b1:b1000,0)+19)
i dont understand the rest of your question!
"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
Perhaps something like this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks so far guys. I don't want the 20 cells displayed below the data validation cell though.
This one? ..................
Yes Fotis. Thank you. I see you hid the column. Any way of doing this without hiding columns?
Last edited by ScabbyDog; 03-14-2013 at 07:32 AM.
I can not think one..!
you can use a dynamic named range see attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks