I have two columns which look like this:
A B
1 DA111 Sarah.a
2 DA444 John.b
I will write names to column C from different file.
I want cell C to find exact name match in column B and if matched enter it's code from column A.
So i wrote my formula like this =VLOOKUP(C1;A:B;1;FALSE)
It gives me error of course because of mixed letters/numers. How can i fix it?
=IFERROR(INDEX(A1:A???,Match(C1,B1:B???,0)),"NO MATCH")...where ??? is the last row of your code/name data.
Columns A and B and with fixed data.
Column C is where i will enter new data.
Column D is where I want the vlookup to work from C to B if matched - get data from A.
Hi rolex
It is always a better option to upload the sample workbook...you will get reply faster...
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
This is the workbook
For sample...
Please Login or Register to view this content.
Last edited by jhren; 04-16-2015 at 08:15 AM.
Hi,
I have also added some data on sheet 2....
check which solution work for me......
here is your attachment....Example.xlsx
If there are other things you want to ask please feel free......
thanks, it worked!
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks