Picking Data from another sheet

R

Rich

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
 
R

Roger Govier

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,False)
 
Top