Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Fernando
If your table is like this: you can use this formula =INDEX(B2:E5,MATCH(A8,A2:A5,0),MATCH(B8,B1:E1,0)) I'm using A8 & B8 cell to set my criteria "Island 3 with Island 2" Change the range to your needs. A B C D E etc... 1 island 1 island 2 island 3 island 4 2 island 1 5 25 40 55 3 island 2 15 20 22 45 4 island 3 12 14 18 22 5 Island 4 4 14 12 16 HTH John "Fernando Lopes Jr" <Fernando Lopes wrote in message ... I need a fucntion that is able to read a table cross the data from the rows and colums and return a value. The table is 9x9 in the colums and rows I have the name of nine islands the data is the distance between then. I need a function that I say island 2 and island 3 and it returns the distance from the table. Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
'TABLE' array function | Excel Worksheet Functions | |||
Help needed !! Look Up Table function ?? | Excel Worksheet Functions | |||
TABLE function? | Excel Worksheet Functions | |||
=TABLE function | Excel Discussion (Misc queries) | |||
What does this function do? {=table(D19,D21)} | Excel Worksheet Functions |