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

[pdfaust]

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]

Hi,

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

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

Hope that helps...

[pdfaust]

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