View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hero_honda
 
Posts: n/a
Default Excel Vlookup Problems Help!


A100 AS OVERAN FMS 11,500
V80 AS OVERAN FMS 11,500
WIN AS OVERAN FMS 11,500
YB100 AS OVERAN FMS 11,500

A100 AS SHOCK DEPAN FMS 65,000
CB100K3 AS SHOCK DEPAN FMS 65,000
FORCE-1 AS SHOCK DEPAN FMS 50,000
GL-PRO AS SHOCK DEPAN FMS 67,500

SMASH AS OVERAN KGW 50,000
V80 AS OVERAN KGW 60,000
WIN AS OVERAN KGW 75,000
YB100 AS OVERAN KGW 95,000

A100 AS SHOCK DEPAN KGW 165,000
CB100K3 AS SHOCK DEPAN KGW 165,000
FORCE-1 AS SHOCK DEPAN KGW 150,000
GL-PRO AS SHOCK DEPAN KGW 167,500


OK here an example... On the invoice, brand is bery important.. diff
brand .. difference price. 3 different type of drop down list... can
u help? of coz the price is easy.. just have to use vlookup =)


--
Hero_honda
------------------------------------------------------------------------
Hero_honda's Profile: http://www.excelforum.com/member.php...o&userid=34713
View this thread: http://www.excelforum.com/showthread...hreadid=544797