We would have more luck helping you if you showed us the VLOOKUP formula you
are using
All look-up function need the data to be sort either ascending or descending
Also the key (the item looked up) need to be in the first column of the
table
If this is not possible then you have to use a mixture of MATCH and INDEX
Give more details of the data layout and someone will be able to help you.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"smiley61799" wrote in message
...
In column A, B, and F I have look up tables which correspond to my data
in
Columnd D. Everything works great until as long as D11 data is
alphabetically before D12, but if I try to enter things which are not
alphabetical I yield results. How do I correct this?