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's not pasting it right. It for some reason looses track of where the look up "table" is at. Could anyone help? Thank you thank you thank you in advance.
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?
Use
=LOOKUP(O372, Sheet1!$A$2:$A$12, Sheet1!$B$1:$B$12)
or
=VLOOKUP(O372, Sheet1!$A$2:$B$12, 2)
or
=XLOOKUP(O372, Sheet1!$A$2:$A$12, Sheet1!$B$1:$B$12, "", -1)
Hmm That didnt work either. Thank you for helping me. So essentially what I want to do is when I punch in any number from 0-150 I want the cell next to it to say 359. If I punch in a number from 150-250, then I want the cell next to it to say 361. if I punch in a number between 250-400, then I want that cell next to it to say, and so on as shown in this picture below. Do you think you could help with that? Thank you so much again.
