VLookup

J

Jeff

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
 
D

Don Guillett

You did not share your lookup table or your formula.

--
Don Guillett
SalesAid Software
[email protected]
Jeff said:
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
Click to expand...
I formulate my Vlookup to make sure that Excel goes to each "*" in my
worksheet ?
 
P

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

Jeff said:
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
Click to expand...
I formulate my Vlookup to make sure that Excel goes to each "*" in my
worksheet ?
 
Top