SV650.org - SV650 & Gladius 650 Forum - View Single Post

18-01-09, 02:13 PM

The Offset() function is the one you're looking for, combined with Match(). It's probably better to google for examples, but I'll still try here:

Lets assume I have a list of bikes down column A, with a header, so the data we're interested in is A2:A20. In the first row, we have a list of dates, ranging B1:Z1. In this table, we have the name of the rider, for any given bike, on any given date.

To find the rider of the SV650 on 17/01/09, you'd do the following:
=Offset(A1,Match("SV650",A1:A20,0)-1,Match("17/01/09",A1:Z1,0)-1)

NB, the Match()-1 is needed to correct the range values.

HTH.

18-01-09, 02:13 PM	#3
Baph Guest Posts: n/a	Re: HELP! Microsoft Excel doing my head in!! The Offset() function is the one you're looking for, combined with Match(). It's probably better to google for examples, but I'll still try here: Lets assume I have a list of bikes down column A, with a header, so the data we're interested in is A2:A20. In the first row, we have a list of dates, ranging B1:Z1. In this table, we have the name of the rider, for any given bike, on any given date. To find the rider of the SV650 on 17/01/09, you'd do the following: =Offset(A1,Match("SV650",A1:A20,0)-1,Match("17/01/09",A1:Z1,0)-1) NB, the Match()-1 is needed to correct the range values. HTH.