Forum Discussion
LOOKUP formula
Hello, I need help. I have a spreadsheet where I want to use the LOOKUP formula and I got it to work just fine. The issue is where I try to copy and paste the cell to another cell to do the same, it'...
Hmm that didnt work either. So essentially what I want to do is when I punch in a number from 1-150, I want the cell next to it to say 359. And if I punch in a number from 150-250 , then I want the cell next to it to say 250, and so on like on the picture I attached above. Any help is greatly appreciated!!!
You write "And if I punch in a number from 150-250 , then I want the cell next to it to say 250".
I don't understand that - can you explain?
