can anyone help me regarding the question, i am not able to get the proper answer. using vlookup i have extract the whole
name from the provided raw data now i want to get the first name only
like newyork,ny-incorrect
newyork-correct
can anyone help me regarding the question, i am not able to get the proper answer. using vlookup i have extract the whole
name from the provided raw data now i want to get the first name only
like newyork,ny-incorrect
newyork-correct
this maybe a bit messy
Are you looking up newyork,ny and then only want to display newyork
if so
=LEFT(VLOOKUP(B2,$A$2:$A$10,1,FALSE),FIND(",",VLOOKUP(B2,$A$2:$A$10,1,FALSE),1)-1)
Where the names are in Column A
and the value to lookup is in B2
Otherwise attach a sample - see yellow banner on how to load a spreadsheet - so we can see your data layout, and results expected - with a description why
this does 2 lookups, hence why i say its messy and not sure how it will perform on large data files
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks