Thread: If value between 2 numbers
View Single Post
  #1   Report Post  
CMoHorn CMoHorn is offline
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by Spencer101 View Post
Would the VLOOKUP values always be whole numbers or could they be decimals too?

If always whole numbers then a simple VLOOKUP table would work.

If decimals then a long winded IF AND nested formula would be needed.
Spencer, thanks for the reply. The value would always be a whole number. I'm not exactly sure how to use the VLOOKUP table in the formula above though.
Reply With QuoteReply With Quote