Ok, so what I'm trying to do has got me stumped.
In short, I have enormous amounts of data to sort through (as we all do) and I am trying to link them to unique identifiers for easier data maintenance later.
What I want to do is vlookup from the 'solved' sheet a code, which will search the 'data' table and return the 'DFU' code.
I'm not sure if it can be done, but if it can be, I know I'll find someone here who can do it!!
Cheers and thank you in advance.
Starkey
Example 2905.xlsx
Last edited by Starkey; 05-29-2014 at 09:27 PM.
VLOOKUP can only look up a value in the first column of the array, so that won't work. INDEX and MATCH combined might get you there.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I think that's what I need, but I reach my limits of how to use those two at that point.
Are you opposed to a custom function? See attachment.
David
(*) Reputation points appreciated.
=INDEX(data!$A$1:$L$17,SUMPRODUCT((data!$A$2:$K$17=$C5)*ROW(data!$A$2:$K$17)),12)
try this in "D5" of results sheet
Thanks everyone. I think nflsales's solution has worked. My issue right now is the volume of data I'm processing is 25k lines by 11 columns, then multiplied out. My computer is literally shitting itself.
Nevertheless, this does seem to work.
Tinbender, I'll check yours out too just for interests sake.
Thanks all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks