Conditional column search and value return

[Chris2208]

Hi All,

I have attached an abridged version of the spreadsheet I am working on, which has already had help a couple of times from people in here, thanks for that.

What I need to do now is search one tab using a unique value and return another value associated with that value.

In the attached I need to put a formula into 'Fox Raw' column C and D (date set and date retrieved) that will return the date set or retrieved in 'Sites (admin)' while matching the site codes in both tabs ('fox raw column L and 'sites (admin) ' column A.

I hoped an if function would work but I can't get it to. Some like 'if 'fox raw column L' = 'sites(admin) column A' then return to 'fox admin column C' the matching value in 'Sites(admin) column T'.

Thanks for any help.

Cheers
Chris

[Glenn Kennedy]

In C2, copied across and down:

=INDEX('Sites(admin)'!T$3:T$500,MATCH($L2,'Sites(admin)'!$A$3:$A$500,0))

It's not a very good sample as all the answers are the same!!!

[Chris2208]

Brilliant. Thankyou.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.