Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Looking up values in multiple rows
Hi there,
I need to have a vlookup or something that works across rows. For example, I have column A representing time, with A1 through to Axxxx with each cell showing a time for a specific date. So for June 1 we would see the times 08:00, 08:30, 09:00, etc. Then for June 2 we would see the times 08:00, 08:30, 09:00, etc.. For the entire month these same times are noted. Column C is the column that has the data that I want, but I only want a specific time. How do I set this up so that my formula gives me the column C data for 12:30 for every day in June. Thanks, Marie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying Multiple Values without using Macros or ROWS function | Excel Worksheet Functions | |||
How to retrieve multiple values in multiple rows with one criteria | Excel Discussion (Misc queries) | |||
Looking up multiple items and suming the values on their rows | Excel Discussion (Misc queries) | |||
Count on multiple values with duplicate rows | Excel Worksheet Functions | |||
counting rows with same values for multiple values | New Users to Excel |