Formula for if two numbers match

**jaspal** · 2013-07-17, 12:54 PM

The calculation i am after is,

if the number in range (G1:G5) Matches the number in (A1:E1) then = A4 -(answer) otherwise A4.

Thank you for any help

**NBVC** · 2013-07-17, 01:37 PM

Hi,

Before asking new questions, please close off your open threads.

Also, if you are crossposting (as was discovered in a previous thread, please post all links to those threads). Please read this: http://www.excelguru.ca/content.php?184

After that, pertaining to this thread.... I am not sure I get what you are looking for. Please give us some expected results based on the data in the sheet.