I have a workbook that has several spreadsheets. Sheet 1 is the sheet that I
use to total the information from the other sheets. These other sheets have
information download daily into them which comes from a special web page that
was created for our company. So these web downloads have some information
that I am not needing, but the particular word can be in any particular row,
but will always be in column A. I use this word as my control point to see
where to go to get the information that I need, and this starting point
changes daily.

So what I am needing is a formula that will locate this word, it will always
be in column A, and then drop down one line and over two columns to get the
information that is needed.

As an example lets say that Im looking for the word €œName€� in column A; in
column C is showing today €œApple€�, and then in column D showing a percent of
20%. This last bit of information is what I need to gather by way of a
formula. I have cut and pasted this information from several sheets into
sheet 1 each day, and Im getting tired of doing that so was wondering, if
there was a formula that could take care of this.