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: 386
Default Match and Index for Tables

Can anyone tell me how to get the match and index functions to work for an
8x8 table?

So for example I would like the function to take a given text string ec for
example, search for its position in the first table, then look at the second
table and return the value the corresponds to the text string located in the
first box.

Examples - I ask the function to find the value corresponding to; ec the
function returns the value 99, for bh - 4, for ga- 78.

The text string to match is in cell m10, and the top left corner of the
tables begins in cell N10.

Tables below

a b c d e f g h
a aa ba ca da ea fa ga ha
b ab bb cb db eb fb gb hb
c ac bc cc dc ec fc gc hc
d ad bd cd dd ed fd gd hd
e ae be ce de ee fe ge he
f af bf cf df ef ff gf hf
g ag bg cg dg eg fg gg hg
h ah bh ch dh eh fh gh hh

a b c d e f g h
a 20 11 30 33 44 40 78 54
b 20 20 20 20 20 20 20 20
c 20 43 5 90 99 67 60 56
d 20 20 20 20 20 20 20 20
e 20 20 20 20 20 20 20 20
f 20 20 20 20 20 20 20 20
g 20 23 21 12 12 12 12 12
h 20 4 4 4 4 50 43 80

Anyone know? I can't figure out how to get match to look at tables rather
than columns.

Thanks a million
 
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
Find Exact Match using INDEX, MATCH DoubleUU Excel Worksheet Functions 3 August 15th 08 02:42 PM
index(match) Wind Uplift Calculations (match four conditions) JMeier Excel Worksheet Functions 8 August 1st 08 01:45 AM
index match array function-returning only first match, need last. Julie Olsen Excel Worksheet Functions 3 December 29th 06 12:50 AM
How do I display more than one match in a Index/Match formula? Trish Excel Worksheet Functions 0 September 26th 05 10:21 PM
index,match,match on un-sorted data Brisbane Rob Excel Worksheet Functions 3 September 24th 05 10:04 PM


All times are GMT +1. The time now is 08:57 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"