Hi, I am giving myself a headache in working out, what I believe is a simple formula in excel. What I am trying to achieve is to look at two cells on the same sheet and if 1 of the cells matches certain criteria (i.e. names) then it returns the value of another cell on the same sheet to a summary sheet.

I hope this makes sense and look forward to your response.

Perhaps something like this? =IF(OR(Sheet2!A1="Tom",Sheet2!A2="Tom"),Sheet2!C1,"")

or

=IF(OR(Sheet2!A1=Sheet1!A1,Sheet2!A2=Sheet1!A1),Sheet2!C1,"")

Excellent; that works a treat. Many thanks for the post it is greatly appreciated.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History