Two deminsional lookup

[hbabb]

I am trying to do a lookup in a two deminsional array, where both x and y numbers fall in a range to qualify for a specific row or column. When they are qualified i want to retreive the data at the intersecting cell. How is that done?

[NBVC]

USING INDEX/MATCH.

e.g

=Index(TableArray,Match(A1,RowArray,0),Match(A2,ColumnArray,0))

where A1 and A2 contain the values to match in the row headers and column headers, respectively.

The TableArray, RowArray and ColumnArray should be replaced with the range references.

[hbabb]

=INDEX(Sheet3!$A$2:$Q$17,MATCH(U3,Sheet3!$A$2:$Q$17,0),MATCH(V3,Sheet3!$A$2:$Q$17,0))

I have tried the following formula only to get #N/A as a result.

Any ideas?

[NBVC]

Probably should be:

=INDEX(Sheet3!$A$2:$Q$17,MATCH(U3,Sheet3!$A$2:$A$17,0),MATCH(V3,Sheet3!$B$1:$Q$1,0))

[WinteE]

On my site you'll find a VHLOOKUP() function. This is a UDF (User defined function) so you'll have to copy some code to the VBA section.

It works like VLOOKUP() but instead of entering an indexnumber for the column you can enter the columnheader.

Erik