Thanks for the response...i have a few questions.

Do i enter these formulas in the data sheet or the report i am trying to
populate?
Also, how do i get it to return the value into the correct cell on my report?

Thanks again for your help!

"smartin" wrote:

se7098 wrote:
[snipped]
Charlotte is in the data sheet along with customer assistant and job
seeker...customer assistant will be found in column D and job seeker may be
found potentially in columns E-I.

Example:

Charlotte
High Volume Title Job Seeker Testing Evaluation
Sales Associates 3 6 2
Cusomer Assistant 9 7 1

I need to look for charlotte and if found then look in the rows below for
customer assistant and then look for job seeker then if found look one row
down and return the value found directly below job seeker and return that
number to my report in a separate worksheet.

You were not quite consistent in describing what you want, but I think
what you are saying is you want the value under "Job Seeker", in the row
for "Cusomer Assistant" [sic], under the heading "Charlotte".

Here is one way that uses a few "helper columns". Since you say you are
new to some of this I will describe each formula.

I'm guessing you might want to extend this to look for other cities,
other titles, so I worked that in too.

Put the following in K1:N1
Charlotte Cusomer Assistant Job Seeker Value

In K2
=MATCH(K$1,$B:$B,0)
This looks for the city name in column B and tells which row has it.

In L2
=MATCH(L$1,OFFSET(INDIRECT("B"&K2),0,2,999),0)-1
This looks for the title (Cusomer Assistant) in column D, and tells how
many rows below the city name it appears.

In M2
=MATCH(M$1,OFFSET(INDIRECT("B"&K2),1,0,1,8),0)-1
This scans the row below the city name for the opportunity (Job Seeker)
and tells how many columns to the right of B is appears.

In N2
=OFFSET(INDIRECT("B"&K2),L2,M2)
Finally, the value you are looking for! It uses the coordinates we
determined in L2 and M2 to locate the correct value.

With that done, should you want to find a value for another city, title,
etc., just change the cells K1:M1.

Hope this helps!