Formula to search column X for text, when found, copy amount from column Y, but as negative

[geertech]

Dear all,
I need a formula to search Col C for "6-Kadobon-Behandeling", and if found, copy the amount on the same row in Col H into Cell H10, but then as a negative.

The data is exported as CSV from a POS system and needs to be converted and imported into a digital accounting system which requires a counterpart for these amounts.

Searched a lot of threads, but can't get it to work

Any help greatly appreciated!

Thanks in advance,
Remco

 

[philwojo]

Try this:

=(IF(ISERROR(VLOOKUP("6-Kadobon-Behandeling",$C$1:$H$9,6,0)),"",-(VLOOKUP("6-Kadobon-Behandeling",$C$1:$H$9,6,0))))

That will put in a Blank if it doesn't find that, other wise it will it will give you the value H. Put the formula in H10.

Not sure on your range so I put it from 1-9, but update as necessary.

Also assumes your value in H is a number.

 

[geertech]

Thanks so much philwojo; works lika a charm!
This will save me a lot of time on a daily base!

 

[philwojo]

Glad to help.