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

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