R
riccid
Hi All,
I've created a spreadsheet which references a table array hidden in my
spreadsheet which I want to change if that field is changed. This is
effectively a Services quote sheet which I have built as follows:
A1 = References a list in the form of a header row in my (hidden)
table 'Preferred' or Non Preferred' client
Then in my quote Section I have the following columns:
Column A - Task description (manual input)
Column B - Quantity of hours (Manual input)
Column C - Resource Type (A list from the Hidden table, in effect the
first column) 'Level 1' - 'Level 4'.
Column D - Should return the rate of that resource based on two
conditions; A1 (i.e. Preferred or Non Preferred, and the Resource
Type)
Bascially if the Resource is a Level 1 and the client (i.e. A1) is
preferred then the rate will be $90 per hour. If by chance we change
A1 to Nob Preferred I want the 3rd column in the hidden table to be
selected adn therefore change the rate to $120.
I suspect that a VLOOKUP may be the key but I'm having trouble
figuring out how to make it conditional based on the aformentioned so
wold appreciate any helpyou can give me.
I've created a spreadsheet which references a table array hidden in my
spreadsheet which I want to change if that field is changed. This is
effectively a Services quote sheet which I have built as follows:
A1 = References a list in the form of a header row in my (hidden)
table 'Preferred' or Non Preferred' client
Then in my quote Section I have the following columns:
Column A - Task description (manual input)
Column B - Quantity of hours (Manual input)
Column C - Resource Type (A list from the Hidden table, in effect the
first column) 'Level 1' - 'Level 4'.
Column D - Should return the rate of that resource based on two
conditions; A1 (i.e. Preferred or Non Preferred, and the Resource
Type)
Bascially if the Resource is a Level 1 and the client (i.e. A1) is
preferred then the rate will be $90 per hour. If by chance we change
A1 to Nob Preferred I want the 3rd column in the hidden table to be
selected adn therefore change the rate to $120.
I suspect that a VLOOKUP may be the key but I'm having trouble
figuring out how to make it conditional based on the aformentioned so
wold appreciate any helpyou can give me.