I can't seem to figure this out {I'm not to advanced at the formula's but I
can usually figure them out, so please bare with me}

Sheet 1 {Main Report}

I added a column for the county. Due to the format of this report, this
starts on C9 {not including the header row} -- the site is listed on B9

Sheet2 {site & country list- No header}:
Site= A1:A282
Country=B1:B282

Could you provide me the formula using this criteria. I tried using the
VLOOKUP function helper and typing it manually using my criteria but I can't
seem to get it to work.

Thank you so much :-)

"Ilia" wrote:

Let's say your site and list of counties is on Sheet2 in range A1:B100, where
column A contains site number and column B contains county name. You can use
this formula on the sheet containing your report:

=VLOOKUP(A1, 'Sheet2'!$A$1:$B$100, 2, FALSE)

Where A1 contains the site code.

Hope that helps.


"Buttercup" wrote:

Here's the deal:

I have a report that I need to run and is is missing a column that is needed
from it. We have one column with a spefic site # attached but we jwould like
the county to also show. I can run another report with the site # and
country listed. I would like to compare the site #'s from the one report to
the site #'s on the other and if it matches I would like to have the county
associated with that site to be listed.

I hope this is enough information.

Does anyone have the formula to do this? I haven't used formula's that use
another workbook, but I have used formula's on other worksheets. Either way,
please specify if I should paste the second report into another worksheet in
the workbook or not.

Thank you in advance for all your help :-)