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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating copy of sheet into new file results in #REF errors 1
Vlookup cell reference 6
make formula look at diff sheet 5
Copy Formula From Another Cell 2
Dynamic named range reference from external workbook 2
Vlookup and return sheet name also 2
Indirect or substitute? 7
IFERROR TO COMPARE WKSHEET 2

Back
Top