LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 70
Default LOOKUP function syntax across a table?

I am trying to structure a LOOKUP formula which looks across a table of
values, and if it finds a particular value, it reports the ROW NAME's value.

For example, if I have a 10-by-10 matrix of numbers, with ROW NAMEs in
Column A, followed by a matrix of numbers within the table B2:K11:

Employee 1 2 3 4 5 6 7 8
9 10
E1 1.1 3.1 5.1 7.1 9.1 11.4 13.4 15.4 17.1 19.0
E2 1.3 3.4 5.4 7.4 9.4 11.1 13.1 15.1 17.3 19.8
E3 1.4 3.3 5.3 7.3 9.3 11.3 13.3 15.3 17.4 19.9
E4 1.2 3.6 5.6 7.6 9.6 11.6 13.6 15.6 17.6 19.7
E5 1.6 3.2 5.2 7.2 9.2 11.2 13.2 15.2 17.2 19.2
E6 1.7 3.7 5.7 7.7 9.7 11.7 13.7 15.7 17.7 19.6
E7 1.9 3.9 5.9 7.9 9.9 11.9 13.9 15.9 17.9 19.4
E8 1.0 3.8 5.8 7.8 9.8 11.8 13.8 15.0 17.8 19.3
E9 1.8 3.0 5.5 7.0 9.0 11.0 13.0 15.8 17.0 19.1
E10 1.5 3.5 5.0 7.5 9.5 11.5 13.5 15.5 17.5
19.5

I would like to come up with a function (INDEX, LOOKUP, MATCH, etc.) which
would allow me to search the table for a value (say "11.9") and return the
value from Column A (in this case "E7").

Any idea how I should construct the function call?

 
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
Excel 2007 Vlookup Using New Table Syntax [email protected] Excel Worksheet Functions 2 January 8th 08 03:39 PM
Lookup : Syntax Error Steve_n_KC Excel Worksheet Functions 0 June 14th 07 07:59 PM
Variable Table Array in Lookup Function matt_the_brum Excel Worksheet Functions 6 August 4th 06 05:07 PM
What is the syntax for referencing another sheet with 'lookup' ihenderson Excel Worksheet Functions 3 July 31st 06 12:05 PM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM


All times are GMT +1. The time now is 10:14 AM.

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

About Us

"It's about Microsoft Excel"