Hi

If you use the 4th parameter of Vlookup, and set it to False or 0, then the
data does not need to be in a sorted order.
=VLOOKUP($A$3,INDIRECT("'"&A4&"'!$A$3:$K$38"),9,Fa lse)


--
Regards
Roger Govier

"Rich" wrote in message
...
Hi All

I am looking for a formula like VLookup to select data from another sheet.
The VLookup one I have that works is

=VLOOKUP($A$3,INDIRECT("'"&A4&"'!$A$3:$K$38"),9)

The only problem is that the data that is being retrieved has to be in
alphabetical order.

I have tried the following formula

=OFFSET(A3,MATCH(INDIRECT("'"&A33&"'!A1:A100"),0), 6)

However can not get it to work, any help much appreciated.

Richard