LinkBack URL
About LinkBacks
Hi there all,
I have a VLOOKUP combined with CONCATENATEand the gives faulte result,
Can somebody help with this?
RGDS Eric
Hi there all,
I have a VLOOKUP combined with CONCATENATEand the gives faulte result,
Can somebody help with this?
RGDS Eric
You can use this formula. Then you don't need the helper column either. It is an array formula so you will need ctrl + shift + enter to compute.
Last edited by Hawkeye16; 07-17-2014 at 10:55 AM.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
Where is it faulty?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Rows 5, 6, 7, 11, 19, 26, 27, 29, 30, 31, 33
line 5, 6, 7 and 11 all gave color 8 and that is not corrcect
Hawket gave me an answer that looks cool voor me thanks,
rgds Eric
or just
=INDEX(Data!$D$2:$D$35,MATCH($A2&"-"&$B2&"-"&$C2,INDEX(Data!$A$2:$A$35&"-"&Data!$B$2:$B$35&"-"&Data!$C$2:$C$35,0),0))
fyi
the lookup doesn't work as it requires the array to be in ascending order
also its often best when concatenating values together to make them distinct that's why i added &"-"
else
516 19 2
51 619 2
both come out to
516192
Last edited by martindwilson; 07-17-2014 at 11:01 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks