Hi,
Am Tue, 18 Feb 2014 16:26:04 +0000 schrieb reidynem:
HR Premium £28.00 £30.50 £33.00 £64.00
Economy £26.50 £28.00 £29.50 £58.00
SY7 Premium £28.00 £30.50 £33.00 £64.00
Economy £26.50 £28.00 £29.50 £58.00
SY8 Premium £28.00 £30.50 £33.00 £64.00
Economy £26.50 £28.00 £29.50 £58.00
WR Premium £28.00 £30.50 £33.00 £64.00
Economy £26.50 £28.00 £29.50 £58.00
and the table I want to input into would be:
Post code Service No of Pallets Price
HR Premium 1
you have to insert the post code in all rows. And you have to delete the
leading and trailing spaces in your values.
Then you can try it in sheet2 with:
=INDEX(Sheet1!A1:F100,MATCH(A2&B2,Sheet1!A1:A100&S heet1!B1:B100,0),MATCH(C2,Sheet1!A1:F1,0))
and enter the array formula with CRTL+Shift+ Enter.
Or look he
https://skydrive.live.com/#cid=9378A...121822A3%21326
for workbook "PriceList"
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2