View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marc Marc is offline
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?