|
|
Brilliant guys, thanks a lot!!!
"Alan Beban" wrote:
Willie McL wrote:
Hello,
Could anyone help me...
When I enter a vlookup formula, the first matching value is found and
displayed, is there any way of getting the formula to look up the second or
third values, e.g. to look at a trend over a particular week. I have been
able to do this before somehow using these symbols {} but cannot remember
what I done!
Thanks for any suggestions,
Willie
I assume you have different lookup values. If they are numbers, e.g.,
5,3,6, you can array enter a hardcopied formula:
Either =VLOOKUP({5,3,6},B1:D5,3,0) for a horizontal result or
=VLOOKUP({5;3;6},B1:D5,3,0) for a vertical result.
If you mean multiple occurrences of the same lookup value,Jason Morin
has offered a solution (which I haven't tested). You might also consider
the Vlookups function in the freely downloadable file at
http://home.pacbell.net/beban for such a case.
Alan Beban
|