*VBA EXPERTS REQUESTED* Code Needed

[NicoleJ1987]

Trying to help speed up a task at work. Any help would be appreciated. I want to retrieve a value and put it in Cell A5 of Sheet 2, but I must first identify the correct value in Sheet 1 that I need by doing the following.

I want to evaluate/search the an array for a string of (e.g.) the word "Automobile", if this is found in Column A Row 3 of Sheet 1, evaluate the following column of row 3 for the word "Honda" then evaluate the following column of row 3 for the words "Price" and - if all true - retrieve the value "20305.62" from column 4, row 3 and put it in Cell A5 of Sheet 2.

Also, there may be multiple identical lines so I need them to be summed and placed in Cell A5 of Sheet 2. Please help!

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=628262

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).