Quote Originally Posted by JBeaucaire View Post
You can nest 7 if statements together. To go beyond that would require you use a second column to do some followup. 14 IFs would probably take 3 cells.

Are you sure you even need IF? It appears you're looping the same formula over and over looking for a value, and that is what LOOKUP is best suited for.

I added some range markers at the top of sheet5 in green, and changed the formulas on Sheet4 to show how a much shorter LOOKUP gets you the same result (green cells).

Is that cell N14 the one that was giving you problems? It works now.
Hi
E2 is the entry point, N7:N14 pulls the data from sheet 5 depending on the entry in E2 ie 1200

it looks up the corresponding values upto that size and equaling it and fills the data .

does that make sense