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

Colin Legg · #2 02-03-2011, 02:51 PM

Hi,

If I understand correctly, put this formula in A2 and then fill down:

Code:

=VLOOKUP($B2,$C$2:$D$6,2,0)

Hope that helps...

pdfaust · #3 02-03-2011, 03:02 PM

Thanks that 2 in the string was messing me up, I see how it works now. I did not have my array to include that row in the search.

Thank you so much,
Phil

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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