Two Way Lookup question

[Deuces High]

Is there a limit to the number of columns or rows you can use? I have table that is 16 rows deep and 81 columns wide.
For the Row lookup I have =MATCH(H22,B4:B19,0) (which returns the row number) H22 being the cell where I enter my first query.
For the Column lookup I have =MATCH(H23,C3:CE3,0) which returns the column number) H23 being the cell where I enter my second query.
The cell that returns the information using those two Lookups is
{=INDEX(C4:CE19,MATCH(H22,B4:B19,0),MATCH(H23,C3:CE3,0))}
The problem I have is that it will only returns values up the column AB. Any query past that column returns a #N/A…..Not sure what I am doing wrong!

 

[Fluff]

Hi & welcome to MrExcel.
That is not an array formula & does not need the {}
That said it should still return the result, I suspect that your criteria don't match the values in col B or row3

 

[Deuces High]

Thanks Fluff. I used the formula with and without the {} and got the same results. Any query using any combination between any row number and column number up tp AB column works fine, but after that nothing. The columns are numbered by percentage 20% thru 100% and the row is numbered by .05 through 15, so it pretty simple numbers being entered. really stumped on this!

 

[Fluff]

Are those numbers entered manually or by formula?

 

[Deuces High]

Manually.... The last percentage (column) you can enter is 46% which is column AB, after that comes the #N/A

Build Density %	15.0	16 (Row)
Build Height	32.0%	13 (Column)
Unit Number	233 (Results)

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Build Density %	15.0	16
Build Height	49.0%	#N/A
Unit Number	#N/A

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

Check the cells after AB & make sure that they are the correct values, by selecting a cell & looking in the formula bar.
If they look ok, try changing the setting to show 15 decimal places.
There is a good chance that rather having 47% you've got something like 46.999999999%

 

[Deuces High]

BINGO!!!!!! That was it. The cell actually showed 48.9999999% Thank you so much....I was going nuts. Your the best!

 

[Fluff]

You're welcome & thanks for the feedback