Absolute $ or INDIRCET not working inside my formula

[b_rianv]

Good morning all,

For some reason Absolute $ or INDIRECT is not working inside my formula when I add a row to my chart. Formula keeps adjusting.
Here is my formula...=IFERROR(LARGE(IF($B$5:$B$50=$K108,$A$5:$A$50),1),"")
$B$5:$B$50 goes to $B$6:$B$51 AND $A$5:$A$50 goes to $A$6:$A$51..... it can't do that, throws my counts out, needs to stay in this range B5:B50 and A5:A50 when I add a row to chart

Also when I use INDIRECT
=IFERROR(INDIRECT(LARGE(IF("B5:B50"=$K108),INDIRECT("A5:A50"),1),""))))
I keep getting a error with =$K108, which is a cell reference in my formula which the formula needs to look at

So what do I do, or what formula do I need to use to stop this from adjusting as I add rows to a chart to stop formula from adjusting?
Any ideas anyone???

Thank you,

[Special-K]

This should work

=IFERROR(LARGE(IF(INDIRECT("$B$5:$B$50")=$K108,INDIRECT("$A$5:$A$50")),1),"")

Cos they're now text they won't change.

I dont know if you need to do an INDIRECT("$K108") in there, if it changes and you dont want it to put the INDIRECT("") around it as stated in this sentence.

[b_rianv]

=IFERROR(LARGE(IF(INDIRECT("$B$5:$B$50")=$K108,INDIRECT("$A$5:$A$50")),1),"")

giving error.... your formula is missing a parenthesis--) or (.check the formula, and then add the parenthesis in the appropriate place.

[b_rianv]

I click ok and excel highlights the end of the statement where ,"") is.

[b_rianv]

So I add the parenthesis at the end where it hightlights. But now it is saying few to arguments.

[Vikas_Gautam]

Try this...

Please Login or Register  to view this content.

Don't forget to click *

[b_rianv]

I will test this formula and let you Vikas

[b_rianv]

Yes this one works just fine... Thank you so much for your help in this matter...

[Vikas_Gautam]

Thanks for reply..

Vikas Gautam