Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
my data table is as follows:
16-Jun-09 29-May-09 15-May-09 28-Apr-09 7-Apr-09 Slow Slow Slow Dead Dead 1000 1200 1000 1050 1100 0:16.565 0:19.553 0:16.252 0:17.707 0:18.860 0:15.627 0:19.063 0:15.701 0:16.510 0:17.428 0:15.759 0:19.002 0:15.649 0:16.605 0:17.810 0:16.158 0:18.886 0:15.218 0:16.694 0:18.684 1:04.109 1:16.504 1:02.820 1:07.516 1:12.782 56.15 56.47 57.31 55.99 54.41 I am after something that will look up data vertically so if I put in "Slow" it will then look up all the "Slow" columns. I tried using lookup but couldn't get it to work and vlookup only works for one value as far as I can tell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Data Validation with a vlookup formula | Excel Discussion (Misc queries) | |||
How do I copy a vlookup formula without changing the data range? | Excel Worksheet Functions | |||
Array in formula Vlookup changes when data list is added to | Excel Worksheet Functions | |||
VLookup occasionally returns formula with no data | Excel Discussion (Misc queries) | |||
vlookup formula not working with data on separate sheet | Excel Worksheet Functions |