Drawing blank - Need from what I hope simple solution

  • Thread starter Thread starter Ted Jillett
  • Start date Start date
T

Ted Jillett

two part question
first need a cell (A) that represents "=>94, =<100" that cell (B) = A

Then need a vlookup against that table that if 95 entered would result in
the "A"

I'm better than this but I am drawing a complete blank today.
Thank You
Ted
 
I think you need to rephrase this in a bit more detail
Cell A contains a number ?
You want to test if this number lines between 94 and 100?

What does the table look like that will be the subject of the lookup?
best wishes
 
Back
Top