INDEX-MATCH with cell text driven names

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
 
D

Dave Peterson

(With no testing at all)

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

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

Fill Handle in .NET 1
Validation Drop Down Arrow Gone 1
Date time picker 1
Connecting to outlook 5
printer not work with vista 2
Forms 1
I'm not able to select all the tables from sql server 3
Windows Vista-history 4

Top