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