Extracting Data using MATCH and OFFSET

[purceld2]

Can anyone advise of the best way to retrieve data from a different spreadsheet. I am trying to use MATCH and OFFSET

I have two spreadsheet where I use a value in the first one to match the row of data in the other then use offset to extract the data I require. Is this possible as I keep getting an error.

Has anyone got an example of how this is done

Thank you in advance

Regards

 

[barry houdini]

It's probably better to use INDEX and MATCH, rather than OFFSET and MATCH, particularly because OFFSET won't work if the target workbook is closed. E.g. you can use this formula in workbook1 sheet1 to match C1 in from that workbook with A1:A10 in workbook2 sheet1 and return the corresponding value in B1:B10

=INDEX([workbook2.xls]Sheet1!$B$1:$B$10,MATCH(C1,[workbook2.xls]Sheet1!$A$1:$A$10,0))

 

[KWMSeattle]

A couple things come to mind:

1) Could you post your formula?
2) Are you able to use MATCH/INDEX instead of OFFSET?