Hi,
I have attached a workbook sample.
Top left corner is a table (Data1):
First Column there is data in it with spaces before it. And that's why I need TRIM function.
In the second column I'am inserting a VLookup function to search the 1st character (LEFT Function) of column 1 inside Data 2 of column 1 and return values from the second column of data 2 table on the right hand side.
Intended Table below is just what im trying to achieve
Last edited by Eduards; 01-21-2019 at 11:52 AM.
You're better of explaing what you're trying to achievethan saying "how can i combine three excel formulas" ?
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.
How about
Formula:
Please Login or Register to view this content.
Hi, sorry i rushed it. Edited the first post
Thanks Fluff13, mind if you could explain the function?
Also, I would prefer to see left function. It makes more sense for me. Thanks
Last edited by Eduards; 01-21-2019 at 12:02 PM.
Try this with VLOOKUP
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Have a look here to learn about index match https://exceljet.net/index-and-match
I can be done with LEFT but it then needs to ba an array formula
Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
try then:Originally Posted by Eduards
=VLOOKUP(LEFT(TRIM(A5),1)&"*",$L$5:$M$8,2,0)
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
@KOKOSEK
I think the OP to use the LEFT function on column L.
Awesome, exactly what im looking for. Whats the "*" used for?
Looks like I was wrong, although I don't see the point of using LEFT on a single character
@Eduards
Thanks for the Rep
No, he wants to use LEFT on column 1.
Me as well. But we all have different needs
I read it likeWhere column 1 of data2 is column L.to search the 1st character (LEFT Function) of column 1 inside Data 2
But as I pointed out I was obviously wrong
I should of used used a better example inside the sample workbook. In reality the strings I'm using is varied length in a different workbook. But Thanks for your help
OK. You welcome.
How can this be put into a VBA code? I need it as a Macro..
Thanks
Eduardo - did you realise that you have been posting in the Excel formulas section? Shall I move this thread to the VBA section for you?
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you could please, thank you
Last edited by AliGW; 01-22-2019 at 05:20 AM.
Moved.
Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!
For normal conversational replies, try using the QUICK REPLY box below.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks