formulae

[geraldjbartlett]

I need to enter codes into the two columns marked



In the first column “AL” is the job descriptor this narrows it down t
three fee levels £400, £500 & £600



Then there are three or (however many) variables in the next colum
they are 1D, 2D & 3D whichever one I enter creates a fee payable in th
results column.



So if I enter AL and 2D the sum = 500

If I enter VS and 2D the sum = 550 etc.

Please see atttached fil

Attachment filename: job descriptor.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=50756

 

[Bob Phillips]

Hi Gerald,

=VLOOKUP(B9,{"AL",400;"VS",450},2,FALSE)+VLOOKUP(G9,{"1D",0;"2D",100;"3D",20
0},2,FALSE)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)