VLookup

[Guest]

Hi

Here's my problem: I need to look up values which are marked with "*"
Here my worksheet:
* 2,000.1
* 1,000.0
* 5,000.0
When I do a Vlookup, Excel only returns the first value, 2,000.12. How can I formulate my Vlookup to make sure that Excel goes to each "*" in my worksheet ?
Jef

 

[Don Guillett]

You did not share your lookup table or your formula.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hi,

Here's my problem: I need to look up values which are marked with "*".
Here my worksheet:
* 2,000.12
* 1,000.00
* 5,000.00
When I do a Vlookup, Excel only returns the first value, 2,000.12. How can

I formulate my Vlookup to make sure that Excel goes to each "*" in my
worksheet ?

 

[Peo Sjoblom]

You can't, it's better to use a filter instead. There are some formula
workarounds like

=INDEX($B$1:$B$10,SMALL(IF($A$7:$A$10=$D$1,ROW($A$7:$A$10)),ROW(1:1)))

entered with ctrl + shift & enter and copied down until you get an error
will return multiple "hits"
D1 holds the lookup value

--

Regards,

Peo Sjoblom

Hi,

Here's my problem: I need to look up values which are marked with "*".
Here my worksheet:
* 2,000.12
* 1,000.00
* 5,000.00
When I do a Vlookup, Excel only returns the first value, 2,000.12. How can

I formulate my Vlookup to make sure that Excel goes to each "*" in my
worksheet ?