VLOOKUP help 2

[tsouth4]

I created a dropdown list using a data validation table in Excel. My sheet look something like this. Both column B and D are empty and I would like to keep them this way for presentation purposes. I need my Vlookup to return the value in Column D based off the the value I have selected in the cell which I created the validation list.

COLUMN A Col B Col C Col D Col E
Unique Savers 5555 4%
Unique Visitors 8846 8%
Unique Savers 9996 8%
Unique Buyers 96743 15%
Total Revenue 100000 14%

I entered the following formula and it is returning #REF!

=VLOOKUP(A7,A8:A38,5,TRUE)

The value in column E is a formula I created which shows some y/y #'s and I want to compare the change in these based off of which value I am selecting in the validation list. Any help would be greatly appreciated.
-Tim

 

[tsouth4]

My apoligies, the formula I entered looks like this.

=VLOOKUP(A7,A8:A38,5,False)
-Tim

 

[SkipVought]

Hi,
[tt]
=VLOOKUP(A7,A8:[red]E38[/red],5,False)
[/tt]


Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[xlbo]

Your data range must include the lookup values as well so:

A8:A38

should be changed to

A38:E38

However, if you need to copy the formula down, I would suggest amending to:

$A$8:$E$38

to make sure the reference does not move

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[tsouth4]

Thank you both. I figured it was simple however couldn't get my hand around it.

-Tim