View Single Post
 
Old 02-03-2011, 12:54 PM
pdfaust pdfaust is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Feb 2011
Posts: 2
pdfaust is on a distinguished road
Default Need to search a column for a macth and return a result from a third column

I have a list of about 3000 entries to sort. Basically each person will always be a lead on a job and almost always be a backup on another job. I need a formula in column a that will look at the data in column b, search for a match in column c and then return the value from column d - if there is no match it would state that or na is acceptable. Would anyone have any ideas on this?

Thank you
Attached Files
File Type: xls sorting issue.xls (15.5 KB, 8 views)
Reply With Quote