Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pick up values by parameter
Hi,
How can I create following function which collects the information from sheets 2-4 to sheet1? After I have activated Sheets 2,3 and 4, I will give two parameters on Sheet1. A3 is the header and E3 is the value. It will pick up the values on Sheet1 on line 2 (green, 6, 76, 2). Sheet 1 A,B,C,D;E A3,E3 Green,6,32,11 Sheet 2 A,B,C,D;E Red,2,3,7,8 Yellow,4,5,9,6 Green,2,1,1,6 Blue,3,7,9,8 Sheet 3 A,B,C,D;E Red,2,3,7,8 Yellow,4,5,9,6 Green,2,1,22,32 Blue,3,7,9,8 Sheet 4 A,B,C,D;E Red,2,3,7,8 Yellow,4,5,9,6 Green,2,1,1,11 Blue,3,7,9,8 Thank you, Matti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameter Query to return multiple values | Excel Discussion (Misc queries) | |||
My formulas will not pick up pasted values | Excel Worksheet Functions | |||
Formula to pick out number values | Excel Worksheet Functions | |||
how to pick from a range of table values | Excel Worksheet Functions | |||
Pick values from a row | Excel Worksheet Functions |