Picking Data from another sheet

  • Thread starter Thread starter Rich
  • Start date Start date
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
 
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)
 
Back
Top