Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOKUP
Hi, I need help in finding out the result from Sheet 2 consist of 4 col.
Group Catagory Item Balance Watch Qatz H0001 1000 Watch Qatz H0002 1000 Watch Digital H0003 1000 Watch Digitsl H0004 1000 Toy Electro T0001 50 Toy Electro T0002 50 Toy Mech T003 50 I need result as: Watch Qatz H0001 1000 H0002 1000 Digit H0003 1000 H0004 1000 Toy Electro T0001 50 T0002 50 mech T0003 50 Thank you for your help. Kannan. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
LOOKUP
Time to delve into pivot tables
http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm http://www.techonthenet.com/excel/pivottbls/index.htm http://www.dicks-blog.com/archives/2...le-parameters/ best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Krish" wrote in message ... Hi, I need help in finding out the result from Sheet 2 consist of 4 col. Group Catagory Item Balance Watch Qatz H0001 1000 Watch Qatz H0002 1000 Watch Digital H0003 1000 Watch Digitsl H0004 1000 Toy Electro T0001 50 Toy Electro T0002 50 Toy Mech T003 50 I need result as: Watch Qatz H0001 1000 H0002 1000 Digit H0003 1000 H0004 1000 Toy Electro T0001 50 T0002 50 mech T0003 50 Thank you for your help. Kannan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
macro to lookup value and open tab based on lookup value | Excel Programming | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) |