INDEX-MATCH with cell text driven names

  • Thread starter Thread starter NEAL CARTER
  • Start date Start date
N

NEAL CARTER

Hi, I've read through a few posts that are close to what I'm trying to do but i can't get it to work.
I'm constructing a fantasy F1 spreadsheet while i'm bored off work sick.
Sheetnames in workbook DriverSummary, AUS, MAL, CHN, BHR,.....for each round/country of the season.
Each sheet race sheet has a column for car number in called AUSarray, MALarray etc. AUSREF is cell A1 on the race sheets
My current formula in the diver summary works well and is shown below. I have N() to return 0 when a race hasn't happened yet so that my sum() works.
=N(OFFSET(AUSREF;MATCH($A4;AUSarray;0)-1;B$1;1)).
With AUSREF and AUSARRAY written in cells B2 and B3 I'd like my formula in B4 to be something like..

=N(OFFSET("name written in B3";MATCH($A4;"Name written in B4";0)-1;B$1;1)).

Many thanks

Neal



EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx
 
(With no testing at all)

=N(OFFSET(indirect(b3);MATCH($A4;indirect(b4);0)-1;B$1;1))
 
Back
Top