2 Matching Cells returning another value

Microsoft Excel 2003 (full)
August 25, 2009 at 07:27:03
Specs: Windows XP
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.


See More: 2 Matching Cells returning another value

Report •


#1
August 25, 2009 at 07:39:03
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,"")


Report •

#2
August 25, 2009 at 07:50:31
Excellent; that works a treat. Many thanks for the post it is greatly appreciated.

Report •

Related Solutions


Ask Question