Cross reference table

**Zheno** · 01-26-2010, 05:00 PM

Hey!

First as said in title i have no idea what these kind of tables is called in English and i didnt know how to formulate me when it came to the title (so hint me with a "right" name for this kind of table)

To the point i have alot of these cross reference tables. What i mean is table that have a horizontal titelbar (row) and a vertical titlebar (column) and in the table you have the diffrent stats or whatever that can be within it.

Im having a really hard time expaining this so im just uploading a excel file with a little explanation of what im after

**NBVC** · 01-26-2010, 05:03 PM

Try:

=INDEX($C$2:$H$7,MATCH(C12,$C$2:$C$7,0),MATCH(E12,$C$2:$H$2,0))

**Zheno** · 01-27-2010, 09:16 AM

Originally Posted by NBVC

Try:

=INDEX($C$2:$H$7,MATCH(C12,$C$2:$C$7,0),MATCH(E12,$C$2:$H$2,0))

Thanks for your answear

a little problem tho, when i try this out after alittle modication i get the #Name? error. Is it possible for you to upload the lathunt.xls spreadsheet with the formula in to see if it works?

**NBVC** · 01-27-2010, 09:24 AM

Sure.. see attached.

Note that error probably means a typo in the syntax of your formula....

**Zheno** · 01-27-2010, 05:01 PM

Originally Posted by NBVC

Sure.. see attached.

Note that error probably means a typo in the syntax of your formula....

Thank you! works perfect now, and yes im pretty sure that there was something that was written in wrong.

Once again thanks. I should have asked about this way last week when i really needed it. Had to do it the hard way last time.