
David Davala
Member
Members

Forum Posts: 26
Member Since:
October 21, 2020
October 21, 2020

I want the attached spreadsheet to do the following.
A selection is made in cell B2 of the "assumptions" tab. Each of the available selections has a named Array.
In the tab "Q's etc", column B, starting at row 5, should look up the value from the selected Named Array.
The value from the Named Array should be the value in column B that matches Column A.
Cell H14 on "Q's etc" is my attempt. It is returning "REF!"
I hope I explained this well enough.

Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 412
Member Since:
December 20, 2019
December 20, 2019


Velouria
London or thereabouts
Moderator
Members

Trusted Members
Moderators

Trusted Members
Moderators

Forum Posts: 618
Member Since:
November 1, 2018
November 1, 2018

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Riny van Eekelen, YANINA TRIGO
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Sopi Yuniarti
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
Forum Stats:
Groups: 3
Forums: 24
Topics: 6216
Posts: 27250
Member Stats:
Guest Posters: 49
Members: 31897
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
