VLOOKUP is tricky. Copy and paste the formula you're using into a response.
Hard to diagnose without looking at your formula.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Patricia Lynch" wrote:

when using vlookup on a list - I often find that I get N/A as an answer
unless I retype the item I am looking up. When I retype the value that I am
looking up, the correct corresponding value is then pulled from the list....
is there a workaround for this other than to retype every value you have to
look up?
thanks