Find string and return corresponding cell value

[sankaricwai]

Hi,

Please suggest the formula for the below attachment.

Here, I want to add all the Positive Strings as gross deferred tax assets and all the Negatives strings as gross deferred tax liabilities expect valuation allowance.
The valuation allowance should be less from the gross deferred tax assets and will not add to the Liabilities.

Hence I need the formula for the below presentation

Gross deferred tax assets ******* (all positive figures)
less: valuation allowance ******* (if the string matches "Tion Allow", it should be deduct from the tax assets)
Gross deferred tax liabilites *******(all negative figures)

Please send the formula for the below case.

Thank you,

T. Uma Sankar.

[sankaricwai]

HI,

I have a data at B:E range, where B column contains strings and C,D,E columns contains values in that B column I need to find a string "Valuation Allowance" and return the value from the corresponding columns and paste those vlaues to the C8,C9,C10.

And one morething the string "Valuation allowance" should be matched with the H3:H8 list even if it matches with partial string in the B column.

Please suggest me any code or any formula for this.

Please check the attachment and help me in this regard.
Workings.JPG