Hi,
I am trying combination of vlookup & hlookup. I have 2 tables. Table 1 contains Item price list for customer, dealer & stockest. Column A(Item Name), column B(MRP), column C(Dealer price), column D(stockest Price). Table 2 contains Customer list with category. column A(Name), column B(category)
1st Sheet:
Item MRP Dealer Stockest
R1 1400 1022 980
R2 1920 1459 1402
R3 2880 2188.5 2103
R5 4800 3647.5 3505
R10 9600 7295 7010
S1 2800 2044 1960
S2 3840 2918.4 2803
S3 5760 4377.6 4204.5
S5 9600 7296 7007.5
S10 19200 14592 14015
2nd Sheet:
Name Category
Alekha Marketing (P) Ltd. Stockest
Brainy Bytes Stockest
DIGIT COMPUTERS Dealer
Jaiswal Comp & Peripherals Dealer
Kabir Textile Stockest
Micronix Infosolutions Ltd. Dealer
Navdha Computer & Printers Stockest
Neelam Sales Agency Dealer
RIIT Computer Technology Stockest
S.M. Infotech Stockest
Shrikrishna Kripa Computers Dealer
Unique Computer Dealer
Zoom & Jet Dealer
Sheet 3 is the Order booking sheet with many columns like (Name,Item,Qty,Category,Price,.....) I succeed in finding "Category" by using vlookup. Now I have Item name in columnB & customer category in columnD. I want to get the correct price as per the customer category. I tried to find its solution but was not successful. Can someone help me ?
Thanks,
Regards
Kailash Katkar
I am trying combination of vlookup & hlookup. I have 2 tables. Table 1 contains Item price list for customer, dealer & stockest. Column A(Item Name), column B(MRP), column C(Dealer price), column D(stockest Price). Table 2 contains Customer list with category. column A(Name), column B(category)
1st Sheet:
Item MRP Dealer Stockest
R1 1400 1022 980
R2 1920 1459 1402
R3 2880 2188.5 2103
R5 4800 3647.5 3505
R10 9600 7295 7010
S1 2800 2044 1960
S2 3840 2918.4 2803
S3 5760 4377.6 4204.5
S5 9600 7296 7007.5
S10 19200 14592 14015
2nd Sheet:
Name Category
Alekha Marketing (P) Ltd. Stockest
Brainy Bytes Stockest
DIGIT COMPUTERS Dealer
Jaiswal Comp & Peripherals Dealer
Kabir Textile Stockest
Micronix Infosolutions Ltd. Dealer
Navdha Computer & Printers Stockest
Neelam Sales Agency Dealer
RIIT Computer Technology Stockest
S.M. Infotech Stockest
Shrikrishna Kripa Computers Dealer
Unique Computer Dealer
Zoom & Jet Dealer
Sheet 3 is the Order booking sheet with many columns like (Name,Item,Qty,Category,Price,.....) I succeed in finding "Category" by using vlookup. Now I have Item name in columnB & customer category in columnD. I want to get the correct price as per the customer category. I tried to find its solution but was not successful. Can someone help me ?
Thanks,
Regards
Kailash Katkar