Formula for if two numbers match

jaspal

New member
Joined
Jul 12, 2013
Messages
10
Reaction score
0
Points
0
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
 

Attachments

  • Excelhelp.xlsx
    8.9 KB · Views: 14

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
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.
 

jaspal

New member
Joined
Jul 12, 2013
Messages
10
Reaction score
0
Points
0
Sorry didnt realise about the rules on cross posting
 
Top