Hi guys i need your help.
I must match column A and column B to return the column C
In colA there are all my countries
In column B there are all my countries code and countries
I want get the colC where all my colB match than colA
So, I try to use functions but my excel said me error!
Can anyone upload a .xls project please?
Sorry for my eng :D
Immagine.png
Please attach a workbook, rather than an image.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
In cell C1, enter:
Formula:
Please Login or Register to view this content.
and copy down.
attached!
Not works functions
I don't know why.
Thank you Olly
In C2, enter:
Formula:Please Login or Register to view this content.
and copy down.
This will still return #N/A for a lot of rows, where your source data (in column A) is unmatched or ambiguous - for example, "BELGIO" doesn't exist in column B...
I just tried right now! But still the prob, excel said me #name? in colC
Please attach a workbook showing the #NAME? error, so I can see what you've entered.Originally Posted by ozza89
I can't save the file .xsl with the function
I attached the file without fuction
Thks Olly
How can I help you if you don't show what you are trying??
Let me repeat: in C2, enter;
Formula:Please Login or Register to view this content.
Copy and paste this to range C3:C219.
If this shows #N/A, it's because the value in column A for that row is not found anywhere in column B.
If you have a different type of error, please save your workbook with the formula in, and attach that.
Hi Olly thanks for the help CERCA.VERT is the translation of VLOOKUP
countries_07013.xlsx
You've not entered the formula exactly as I typed it.
In cell C2 you have put:
Formula:Please Login or Register to view this content.
I told you to put:
Formula:Please Login or Register to view this content.
See the difference? You've ommitted the column index number parameter. You've also entered the lookup range as a relative reference.
Try using EXACTLY what I showed you.
45.jpg
Ok, but isn't working ^^
<sigh>
I think I'm out of this one...
countries_07013.xlsx
.... ....
Last edited by ozza89; 03-07-2014 at 10:42 AM.
try this one
=VLOOKUP("*"&SUBSTITUTE(LEFT(A2,5),"*","")&"*",$B$2:$B$285,1,0)
Last edited by AlKey; 03-07-2014 at 10:47 AM.
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
hi,
follow what Olly said and it works!
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Are you using a foreign language version of excel and putting the formulas in as they are for English versions?
also see find or search and match function for it.
=VLOOKUP("*"&LEFT(A2,4)&"*",$B$2:$B$247,1,FALSE).......... try this also
=CERCA.VERT("*"&ANNULLA.SPAZI($A3)&"*";$B:$B;1;FALSO)
wORKED LIKE A CHARM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks