Thanks for your response, but it didn't solve the problem - I've got the
last part of the vlookup-formula like the one you described. Any other
suggestions?
Karthik skrev:
Hi Traima
A vlookup formula has 4 arguments
=vlookup("what", "where", "column no of the desired result in the
lookup table", "what if not found")
It seems that you are not entring the last arguement. Enter the last
argument as False or 0. This will tell the function to lookup for exact
match. If this argument is left (as it is optional), excel will try to
find the closest match... and put that value).
Now try this and let me know if this solves your problem.....
Thanks
Karthik Bhat
Bangalore
|