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'...
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.