Find a cell and return value of cell next to it

[Guest]

Good morning. I hope there is an easy answer for this. I track my website
stats in Excel to create trends and charts. I have a specific landing page
that shows up in the monthly overview reports that I would like to track for
changes from month to month.

In column "E" I have a list of all landing pages for the month. In column
"F" is the total number of times the landing page was hit for the month. Page
name and hit results are always in these locations and are always right
together.

I would like to get a formula that will search out the landing page title
(column "E"), and then read and return the value of hits in the column next
to the reference (column "F").

Any suggestions?

Thank you,
jeff

 

[Guest]

look at the VLOOKUP function

your formula will look like this

=VLOOKUP(A1,E1:F100,2,0)

the first reference (A1 in example) is the value you are looking up
the second reference (E1:F100 in example) is the table you are looking in
the third entry (2 in example) is the column number you are retrieving data
from
the fourth entry (0 in example) is telling excel that you are looking for an
exact match (it always necessary for text).

 

[Guest]

Thanx Sloth. Formula was spot on. Think your explanation helped just as much
as the formula.

Had to fiddle a bit with the 3rd value. Was not sure if it was column from
A1, but have discovered that it is column # in relation to the column with
the lookup reference.

thanx for the help,
j