A B C HEA 220 1,2 HEB 240 (25%) HEB 240 5,8 VKR 260 8,3 IPE 280 23,5
I have the data above. cell C1 is a dropdown list. How can I make a lookup function That doesnt take in consideration of the percentage in the lookup_value. Now it gives me the wrong answer.
Please Login or Register to view this content.
Thanks!
Last edited by RinorM; 05-03-2014 at 11:43 AM.
maybe like this
=LOOKUP(LEFT(SUBSTITUTE(C1;" ";""),6),$A$1:$A$4;$B$1:$B$4)
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
RinorM, Good afternoon.
Try to use:
=VLOOKUP(LEFT(C1;7);A1:B4;2;FALSE)
Is it what you want?
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
I get a number when I try the codeBut then when I change the values inside of the drop down list ( cell c1) it doesnt work anymorePlease Login or Register to view this content.
I have no idea what your data in C1 looks like. You only show one example.Originally Posted by RinorM
I get a number when I try the codeBut then when I change the values inside of the drop down list ( cell c1) it doesnt work anymorePlease Login or Register to view this content.
The Data in C1 is a drop down list containing 4 rows, in which all contains the values in column A.
Thanks
Book1.xlsx
I have attached the workbook. The code youve helped me with is in cell C178
Sorry, but your explanation is not enough. Obviously there are not the same as in column A. there as spaces, parenthesis and percentage signs.
Paste this code in the same place (C178)
How can I modify it to get the result I am afterPlease Login or Register to view this content.? Thanks mister.
Try this
=LOOKUP(LEFT($B$3,7),$A$175:$A$305,$B$175:$B$305)
or this
=VLOOKUP(LEFT($B$3,FIND("(",$B$3)-2),$A$175:$B$305,2,0)
Last edited by AlKey; 05-04-2014 at 06:40 AM.
Forgot to add. Change comma to semicolon in formula
It worked superb. Thank you very much and good job!!
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks