Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.
She has some nice tips to help find these problems (numbers as text in one
location, numbers as numbers in the other--or even extra spaces
(leading/trailing/embedded) in one, but not the other.
Kristin wrote:
Can someone please help. I have a V-Look up that works perfect when it takes
info from spreadsheet 1 and transfers it to spreadsheet 2, but when I try to
take info from spreadsheet 2 and transfer it to spreadsheet 1, it is not
working properly. Please help!!!!!!!
Thanks!
--
Dave Peterson