Link to home
Start Free TrialLog in
Avatar of excel learner
excel learnerFlag for United Kingdom of Great Britain and Northern Ireland

asked on

value in the last record

Dear experts
Need an excel based formula which check for unique value in column A (variable) and then post 10% in column D.

Kindly help.

thank you
value-in-the-last-record.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of experts1
experts1
The formula below assumes you are looking
for a value of 500 in range A2:A8 and returns
10% of value if found, otherwise blank cell.

=IF(ISNUMBER(MATCH(500,$A$2:$A$8,0)),INDEX($A$2:$A$8,MATCH(500,$A$2:$A$8,0),1)*10%,"")