Need to search a column for a macth and return a result from a third column

pdfaust · #1 02-03-2011, 12:54 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combo Box in whole column	ioustinos	Excel	1	09-01-2010 01:24 AM
Column width	markg67	Word	2	06-07-2010 07:40 PM
magazine column style	Nasser	Word	4	04-21-2010 02:41 PM
From Excel column to coma	saatfj	Excel	2	04-15-2010 09:59 PM
Last Number in a Column	paulrm906	Excel	1	12-05-2008 07:51 PM