Nested IF or FOR and IF condition - New to this function - Help needed

Hello Team:

Here is the screen shot of the problem. I am looking for help for formula in Column C7

excel.png

in general, from your description in the sheet I would advise you to use a vlookup, something like =VLOOKUP(G6,Tradesize,2,TRUE) but with a balance below your lowest value in J:K it will return #N/A so maybe add IFERROR to it? =IFERROR(VLOOKUP(G6,Tradesize,2,TRUE),"")

As I noted based on what you wrote and the values you had it would return #N/A.
I was not completely clear on your requirements.
your note says

in column C2 I want to compare G6 and put column K values here. for eg: if the value is above 11000 and less than 13000 then it should be 1 if it is above 13,000 but less than 16000 it should be 2 etc.

But your example in cell C2 is 10000 which is not in your lookup table. A vlookup will work for a table where your values are in ascending order and you use "TRUE" at the end of the statement but if your value is below the lowest range then I don't know and the formula doesn't know what to do with that. So what do you expect the value to return if the value is below 11000 (such as 10000)?

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.