LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Looking for a formula to look up data - Not vlookup

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Data Validation with a vlookup formula Tanya[_4_] Excel Discussion (Misc queries) 3 June 2nd 09 12:22 AM
How do I copy a vlookup formula without changing the data range? VickyL872 Excel Worksheet Functions 2 May 27th 08 06:45 PM
Array in formula Vlookup changes when data list is added to Wileyb Excel Worksheet Functions 4 March 23rd 08 05:56 PM
VLookup occasionally returns formula with no data Ted Jillett Excel Discussion (Misc queries) 3 August 9th 07 01:48 PM
vlookup formula not working with data on separate sheet akee Excel Worksheet Functions 18 March 16th 06 03:18 PM


All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"