LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default Match - #N/A

Short question: What am I doing wrong?

I have a range of cells:

The range of cells (C22:ap34) is populated by the formula:
=INDIRECT(C$4&"!E"&$A22) thru =INDIRECT(AP$4&"!E"&$A34) - this created
a summary table pulling the values from other sheets as indicated by
the column header, always found in row 4.

In cell C20, I have the formula: =MAX(C22:AP34) - which shows me the
max value in that range.

In a cell, adjacent to the cell showing the max value, I want to show
the row and column header that matches that maximum value.

I have entered and INDEX/MATCH formula, but it will only result in a
"#N/A" error. I have tried it using the actual number instead of the
cell reference (C20) to the max value. I have tried to enter the match
formula on its own. I am using the ,0 parameter for an exact match, but
the same "#N/A" appears if I change it to ,1 or ,-1. Here's that exact
formula:

=INDEX(C21:AP21,MATCH(C20,C22:AP34,0))

The column headers are repeated on C21:AP21.

What am I doing wrong? Is the range too large - is it the formula that
populates the range?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Look up data in colum a and find match in colum b Chris(new user) Excel Discussion (Misc queries) 1 March 22nd 05 01:41 PM
Look up data in colum a and find match in colum b Chris(new user) Excel Discussion (Misc queries) 1 March 19th 05 09:27 PM
Match Function arguments Stan Altshuller Excel Worksheet Functions 3 March 11th 05 08:48 PM
Find a match that;s not exact Phyllis Excel Worksheet Functions 0 November 8th 04 08:12 PM
Vlookup, Index & Match Phyllis Excel Worksheet Functions 1 November 8th 04 06:11 PM


All times are GMT +1. The time now is 12:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"