Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function or formula
Hello being relativly new to some of excels advanced features i was hoping
for some help I have a price list in excel format it has product codes down column a product description in column b rrp ex vat in column c rrp inc vat in column d i wish to have some sort of form set up so i can type a product code in one box, and a selling price either inc vat in one box or ex vat in another box, and the form to look up the relavent product and tell me as a % off of either the rrp inc or rrp ex vat(which ever chosen) my selling price is Is this possible or will i need to use accses or some other program Many thanks for any help Martin |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function or formula
=SUMPRODUCT(--(A2:A100="your product code"),--(B2:B100="inc vat"),C2:C100)
Adjust to suit "MArtin" wrote: Hello being relativly new to some of excels advanced features i was hoping for some help I have a price list in excel format it has product codes down column a product description in column b rrp ex vat in column c rrp inc vat in column d i wish to have some sort of form set up so i can type a product code in one box, and a selling price either inc vat in one box or ex vat in another box, and the form to look up the relavent product and tell me as a % off of either the rrp inc or rrp ex vat(which ever chosen) my selling price is Is this possible or will i need to use accses or some other program Many thanks for any help Martin |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function or formula
Ignore my first post
=INDEX(C2:C100,MATCH(1,(A2:A100="your product code")*(B2:B100="inc vat"))) ctrl+shift+enter, not just enter "MArtin" wrote: Hello being relativly new to some of excels advanced features i was hoping for some help I have a price list in excel format it has product codes down column a product description in column b rrp ex vat in column c rrp inc vat in column d i wish to have some sort of form set up so i can type a product code in one box, and a selling price either inc vat in one box or ex vat in another box, and the form to look up the relavent product and tell me as a % off of either the rrp inc or rrp ex vat(which ever chosen) my selling price is Is this possible or will i need to use accses or some other program Many thanks for any help Martin |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function or formula
Forgive me teethless mama as i am new to this i do not under stand your reply,
i would like to just type a product code in either a blank cell or form say in row h a price inc vat maybe below in row h or ex vat maybe below that in row h and for an answer to come up in another cell saying a % off the rrp if this is what you have sent could you break down for me please thanks Martin "Teethless mama" wrote: =SUMPRODUCT(--(A2:A100="your product code"),--(B2:B100="inc vat"),C2:C100) Adjust to suit "MArtin" wrote: Hello being relativly new to some of excels advanced features i was hoping for some help I have a price list in excel format it has product codes down column a product description in column b rrp ex vat in column c rrp inc vat in column d i wish to have some sort of form set up so i can type a product code in one box, and a selling price either inc vat in one box or ex vat in another box, and the form to look up the relavent product and tell me as a % off of either the rrp inc or rrp ex vat(which ever chosen) my selling price is Is this possible or will i need to use accses or some other program Many thanks for any help Martin |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function or formula
sorry i am new to the functions and formulas could you please break down for me
thanks Martin "Teethless mama" wrote: Ignore my first post =INDEX(C2:C100,MATCH(1,(A2:A100="your product code")*(B2:B100="inc vat"))) ctrl+shift+enter, not just enter "MArtin" wrote: Hello being relativly new to some of excels advanced features i was hoping for some help I have a price list in excel format it has product codes down column a product description in column b rrp ex vat in column c rrp inc vat in column d i wish to have some sort of form set up so i can type a product code in one box, and a selling price either inc vat in one box or ex vat in another box, and the form to look up the relavent product and tell me as a % off of either the rrp inc or rrp ex vat(which ever chosen) my selling price is Is this possible or will i need to use accses or some other program Many thanks for any help Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this possible with excel ? | Excel Discussion (Misc queries) | |||
Use of Offset function in array formula | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |