LinkBack URL
About LinkBacks
Greetings,
I want to derive the value of CFmin in the attached sheet using INDEX MATCH formula but it is showing #N/A Error.
Kindly advise how to correct it.
Greetings,
I want to derive the value of CFmin in the attached sheet using INDEX MATCH formula but it is showing #N/A Error.
Kindly advise how to correct it.
=INDEX($G6:$N$13,MATCH($C$3,$G$7:$G$13,1)-1+MATCH($C$4,$I$6:$N$6,1)*MATCH(RIGHT($I4,1),0))
What is the final bit of the formula meant to calculate? It is causing the error (RIGHT($I4,1) = 'm' - is this correct?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi,
Note. Try and avoid merging cells as you have done G:H. Merged cells just cause too many problems and most of us avoid them like the plague. Use 'Center across selection' in the cells formatting area instead.
=INDEX(G7:N13,MATCH(C3,$G$7:$G$13)+1,MATCH(C4,I6:N6)+2)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks Richard,
Its Working
What is the CFmin that must obtain when the following is given?Originally Posted by manoj_b118
Row\Col Reference Dia. dB Module m
Re post #8.
Sorry but I don't understand the question. Please upload the workbook and manually add the results you expect.
I wasn't soliciting help; rather posing a question to the original poster...
What is the value that must obtain?
You need to remove those merged cells, then you can use this formula:
=INDEX($I$7:$K$13,MATCH($C$3,$G$7:$G$13,1)+1,MATCH($C$4,$I$6:$K$6,1))
Hope this helps.
Pete
EDIT: was not able to attach my adjusted file.
EDIT2: Ah, here it is:
Last edited by Pete_UK; 12-22-2015 at 06:23 AM.
If 30 must obtain for the given parameters, try rather:
=INDEX($I$7:$N$13,MATCH(C3,$G$7:$G$13,1)+(LOOKUP(C3,$G$7:$G$13) < C3),MATCH(C4,$I$6:$N$6,1))
which will also produce a correct value when Reference Dia. dB = 26.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks