Getting a cell address and using it

[dudara]

I have a spreadsheet containing production information. I want to b
able to search by date (can do this using VLOOKUP), and extrac
information from the same row as that date.

However, I also want to be able to extract the previous 10 entries a
well, for comparison purposes.

ie I enter a date and find that it is in B95, and the piece of info
want is in C95. I also want to be able to pull out C86-94 and place i
all into a new sheet.

I'd be grateful for any help offered. Thank

 

[Guest]

You may use the INDEX and MATCH functions, there is a good explanations of
these two functions together at:
http://www.contextures.com/xlFunctions03.html
In your case, you may need to substract the numbers of rows from the match
results to get the previous information (that case is not covered in the
examples)

Hope this helps,
Miguel.