Hi there,
I am quite new to excel and have a problem with the v-look up funtion.
I need to look up a value from a diffrent sheet within the same file.
The problem is, I have more than one value in the look up range that
is corresponding to the look up value. V-look up only returns the 1st
value. How can I make sure that my formula returns all the
corresponding values from the look up range?

Any help will be much appreciated.
Thanks.

Dzee.

When you say, "returns" what are you trying to do? sum the values, count em?

"Dzee" wrote in message
m...
Hi there,
I am quite new to excel and have a problem with the v-look up funtion.
I need to look up a value from a diffrent sheet within the same file.
The problem is, I have more than one value in the look up range that
is corresponding to the look up value. V-look up only returns the 1st
value. How can I make sure that my formula returns all the
corresponding values from the look up range?

Any help will be much appreciated.
Thanks.

Dzee.

You could use CountIF to count how many instances of the value occur, or
SumIF to add them all up. SumProduct might also be worth looking into
depending on what you're actually wanting to do.

--
Darren
"Dzee" wrote in message
m...
Hi there,
I am quite new to excel and have a problem with the v-look up funtion.
I need to look up a value from a diffrent sheet within the same file.
The problem is, I have more than one value in the look up range that
is corresponding to the look up value. V-look up only returns the 1st
value. How can I make sure that my formula returns all the
corresponding values from the look up range?

Any help will be much appreciated.
Thanks.

Dzee.