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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up in another sheet for values to return in 1st worksheet
Maybe you can you use INDEX and MATCH as described he
http://support.microsoft.com/kb/214142 The general idea is that you put the month names in Row 1 of Worksheet 2 and your metrics in Column A of Worksheet 2. Then in Worksheet 1 you have a formula that will look for the matching month and metric, then use INDEX to grab the value from the corresponding cell with where the matching row and column intersect. There is a specific example on the web page at the IP address above, to help you build the formula you need. Tip: For an exact match, be sure to use "0" (zero) as the third argument of your MATCH function. "ralph" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up in another sheet for values to return in 1st worksheet
Easiest would be to use 4 instead of April in cell b1 =vlookup(a2,sheet2!$a$1:$z$21,b1,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "ralph" wrote in message ... 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 |
Reply |
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) |