Formula for table array

I would say so yes... but to further assist...

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

When you post a reply use the paperclip icon above the message box to manage attachments (if you can't see it click "Go Advanced" below the message box)

Based on your sample file and narrative in first post I think perhaps:

F6: 
=IF(COUNT($C6:$D6)=2,INDEX('Lookup Table'!$B$4:$G$14,MATCH($D$6,'Lookup Table'!$A$4:$A$14)+ISNA(MATCH($D6,'Lookup Table'!$A$4:$A$14,0)),MATCH($C6,'Lookup Table'!$B$3:$G$3)+ISNA(MATCH($C6,'Lookup Table'!$B$3:$G$3,0))),"")
copied down

DonkeyOte,

What does this part of the formula accomplish?

+ISNA(MATCH($D6,'Lookup Table'!$A$4:$A$14,0))

Edit: never mind, I understand it adds "1" to advance to the next row/column if there is not exact match found.

Consider: A1:A3

1
10
15

Criteria: 12

Requirement: return match position of first number >= criteria

MATCH(12,A1:A3) --> returns 2 given 10 is the last value <= criteria

given we want to return 3 as 15 is the real value we want we can just test to see if 12 exists in the range, if it does the answer stands, if not add 1 to result...

ISNA(MATCH(12,A1:A3,0))

if the above returns TRUE we know 12 does not exist in A1:A3 so we add 1 to result... if criteria were 10 the ISNA would return FALSE thus result would remain as 2.