Excel 2003;
The following returns #VALUE!, which interferes with =SUM
=VLOOKUP(E7,'L-Ups'!$B$8:$E$23,2,FALSE)
The message is:" A value used in the formula is the wrong data type"
I have taken all data, multiplied by 1, copy and paste special as value into
tables.
I have verified that cell E7 on the "L-Ups" Sheet is a number.
I'm stuck.
Any suggestions?
Bookmarks