| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up in another sheet for values to return in 1st worksheet
I have a workbook with 2 worksheets, 1 sheet is a simple summary showing the
current months data and the ytd data (the month would be input by the user) as below. The second sheet will have the month by month information and the ytd. How do I get it to lookup according to month inputted and then pick up the correct corresponding data WORKSHEET 1 Enter Month "Apr" Month YTD Metric 1 Metric 2 metric 3 WORKSHEET 2 Jan Feb Mar APr....... YTD Metric 1 Metric 2 Metric 3 thanks Ralph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| Count values only if matches and return on another worksheet | Excel Worksheet Functions | |||
| Using cell as worksheet name to return data on that sheet | Excel Worksheet Functions | |||
| Find two values in worksheet to return one value | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Threaded Mode
