Hi Peter,
thank you for a quick reply.
Excel reports an error when I place a function. It marks B1,'total.
Tried it both in excell 2003 and 2007...
Seems like it's not happy with a lookup value. I tried some combinations I could have think of, but no luck
I have tried your example using "VLOOKUP" and it works fine. Try this link for an excellent tutorial.
http://www.datapigtechnologies.com/f.../vlookup.html:)
I have not failed. I've just found 10,000 ways that won't work.
Nikolat,
Sorry about delay in replying - I've got forum set up on PC at work.
What I forgot to say in the first reply is that you will ned to go through your lists and get rid of all the trailing spaces in many of the cells. When I use any of the lookup functions VLOOKUP, HLOOKUP, MATCH, etc. I tend to use them to get an exact match between what you are using as the lookup value and what is in the cells in the lookup area.
However, I don't know why you got the 'total in B1, I just tried on a new copy of your file and got #N/A when the trailing spaces were still there. Did you copy the formula using Ctrl C/Ctrl V? Or did you type it in? Have you double-checked for any errors? I've got Excel 2002 SP3, so I might expect 2003, at least, to be OK with the equation - there's nothing special about it really.
Peter
Added copy of your file with equations added.
Last edited by PeterB; 04-16-2007 at 04:22 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks