Drawing blank - Need from what I hope simple solution

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
blank cells having no value 2
need help in fine-tuning a formula that removes blank cells in a column range 3
Simple Logic question? 5
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Sumproduct formula help needed 6
how to highlight changes in my data from one block of cells toanother block of cells? 1
Entries in range that meet simple condition - return as range 1

Top