LinkBack URL
About LinkBacks
I have a list of names running down colume A :
EVANS GEOFR
Holland Tim
Jenkins Lee
Matthews Vaugh
MORTON DAVI
PHILLIPS BOB
ROBERTS SIMO
If Tim is found I need Colume B to say MD
iF Lee is found I need it to say ED and on .
Can you help please ?
I have a list of names running down colume A :
EVANS GEOFR
Holland Tim
Jenkins Lee
Matthews Vaugh
MORTON DAVI
PHILLIPS BOB
ROBERTS SIMO
If Tim is found I need Colume B to say MD
iF Lee is found I need it to say ED and on .
Can you help please ?
Hi,
what about the first name EVANS GEOFR ?
Is your find looking only for Tim and Lee ?
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
it will be looking for both the first and surname. The name colume has both the first and surname in it.
The scenario is I have a list of 30 names each of which falls into one of five job functions. I need the spreadsheet to look at the name and insert the function name into the next column save me manually typing it in each time. Can you help please ?
So the column would need to say if (A1 is either tim walls, john taylor or peter berry then say mechanics for example
Hi,
Why don't you maintain a master file with the name and the designation and then you can do a vlookup against the name.
Attached is an example , i hope you can adapt to your requirement accordingly
That is really helpful. Could you please explain the formula to me thou. I get the lookup Idea but not the formula. Sorry to be a pain
As you can see that we are maintaining the staff list in one of the sheets name "Master_List". Using Vlookup you will query this list and look for the name and in the array and return the 2nd column that is the department data.
=VLOOKUP(A2,Master_List!$A$2:$B$8,2,FALSE)
Vlookup( = The function starts
A2 = is name EVANS GEOFR against which we are going to search in the master_list sheet
Master_List!$A$2:$B$8 = this the array which hold the name and the department (Column A (Staff Name) and Column B (Department Name)
2 = We want the function to return the data in the 2nd column (Department Name)
False = It should be an exact match of the name that we are searching for
) Function ends
Thank you ever so much. I have done this to the document but there are errors occurring and I can't work out why would you please advise see attached sheet. I need this formula to run down the whole column as the data in the first few columns will change
Hi,
Check the comments in the sheet.
xlbiznes, nice formulajust a quick suggestion...its good practice to add the last argument in a vlookup(), just to make sure you dont forget it when you really do need to use it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins,
I seem to have missed that in my replied.xlsx file.
Thank you for your reminder.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks