dear all,
i have applied the formula in A5 of uploaded example file. it should bring the same as the required text but the accurate result did not came. please have a solution for this. or guide me if there is another formula can help.
regards
dear all,
i have applied the formula in A5 of uploaded example file. it should bring the same as the required text but the accurate result did not came. please have a solution for this. or guide me if there is another formula can help.
regards
try
=VLOOKUP(LEFT(B5,34)&"*",E2:G6,3,0)
"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
also,
the E2:C6 should probably look like this $E$2:$G$6
and, i think, the reason it doesn't work for the first to is the text is different than your lookup data
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
please check the example file because exact text is also available in look up data,
=VLOOKUP(LEFT(B5,34)&"*",E2:G6,3,0) i have already tried this also but it give the relative result not exact.
please check it again
column B
"Johnson Baby Wipes*Skin*Care Fragrance Free 64 pcs"
doesn't equal Column E
"Johnson Baby Wipes*Skin*Care Fragrance Free 64 PCS 2+2 FREE"
so the match is not exact,
it worked for the 3rd item because the text does match
See Attachment using Martins solution, and my cell addresing fix as well
Hope this helps![]()
sorry Imram, I NOW see what you are saying, my bad![]()
dear check the column E5 the is equal to B5 "Johnson Baby Wipes*Skin*Care Fragrance Free 64 pcs"
and B6 equal to E6 "Scholl*Cracked*Heel*Repair*Cream*25*Ml"
please check it again B5 is equal to E5 and B6 is equal to E6
try getting rid of the left statement in the vlookup.. seems to work
just use
=VLOOKUP(B5,$E$2:$G:$6,3,0)
Also, the gcolumn numbers don't match the d column numbers, so the c figures come out wrong
Hope this helps![]()
Last edited by dredwolf; 11-15-2012 at 11:49 AM.
dear dredwolf
now its ok but here is another issue that is,
this formula only find the exact match but i need the formula same like(=VLOOKUP(LEFT(B5,34)&"*",E2:G6,3,0)) which also find relative text if exact is not available in data,
so please if you can give me the general formula which work in both condition like,
if same exact text is not available then it should find the relative item,
and if same text is available then it should find the same exact text.
example is
if i want to find the ""Johnson Baby Wipes*Skin*Care Fragrance Free 64 pcs"" from data and this is available in data then formula should bring same result. but on other hand if the relative text like ""Johnson Baby Wipes*Skin*Care Fragrance Free 64 PCS 2+2 FREE"" then it should also find this and vice versa.
please your support.
regards
dear dredwolf
now its ok but here is another issue that is,
this formula only find the exact match but i need the formula same like(=VLOOKUP(LEFT(B5,34)&"*",E2:G6,3,0)) which also find relative text if exact is not available in data,
so please if you can give me the general formula which work in both condition like,
if same exact text is not available then it should find the relative item,
and if same text is available then it should find the same exact text.
example is
if i want to find the ""Johnson Baby Wipes*Skin*Care Fragrance Free 64 pcs"" from data and this is available in data then formula should bring same result. but on other hand if the relative text like ""Johnson Baby Wipes*Skin*Care Fragrance Free 64 PCS 2+2 FREE"" then it should also find this and vice versa.
please your support.
regards
Imran,
Try something like
Formula:
Please Login or Register to view this content.
Hope this helps![]()
thanks dredwolf,
tomorrow i will go to my office and check this with my required data then i will give you confirmation
thanks once again.
imran
you are welcome![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks