It would help it we could see your formula.
VLOOKUP works in all versions of Excel in exactly the same way
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Craig4321" wrote in message
...
I am using the VLOOKUP function in Excel (office 2007) and it is not
working
for me. I checked the forums and they had the usual things to check:
remove
special characters, trim the data, format everything as TEXT, copy/paste
special all formulas to be values, etc. I have already tried these things
before looking for a solution. I was quite well versed on VLOOKUP for
Office
2003 and never had any problems. This is the second time I've had problems
with 2007 and I do not know any other options to try.