subtract if condition?

[Siddharthagrawal]

I have 4 line items in a1 to a4 and a8 to 11

I want vba to start with a8. it will search 27800 in a1 to 4. as soon as it finds it, i want to do b(X) - b(X) in bx value. If value is not there, i want it to be blank
These will be the values from c8 to c11 I need. I am attached the workbook.
Please help
c8 - blank
c9 - blank
c10 - -18 (56-74)
c11 - -1 (97-98)

[modytrane]

You can do it with simple formula in C8.

Drag it down to C11.