Formula for if two numbers match

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

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.

Still cross posting without links http://www.excelforum.com/excel-for...-two-numbers-match.html?p=3326128#post3326128

Sorry didnt realise about the rules on cross posting