At 16:40 09/10/2018 +0100, Budge Noname wrote:
An array has a column of figures derived from a calculation formula
in which some input values are not available and have been returned
as #Err. (Cannot recall error number). In order to use this array in
another calculation formula I wish to quote
An array has a column of figures derived from a calculation formula in
which some input values are not available and have been returned as
#Err. (Cannot recall error number).
In order to use this array in another calculation formula I wish to
quote the array but am getting red line surrounding
I have a simple lookup of a value in a sheet column from a table array
which enters a code for the value in the adjacent cell. This is to
provide room booking information from which I can derive and use a
related code number. (All working well now thanks to Brian)
e.g.- In the sheet row 6 th