It could be the numbers are being recognized as text. Try multiplying the Vlookup formula's by one. Example:
=VLOOKUP(Sheet2!$A1,Sheet1!$A:$D,2,FALSE)*1
It could be the numbers are being recognized as text. Try multiplying the Vlookup formula's by one. Example:
=VLOOKUP(Sheet2!$A1,Sheet1!$A:$D,2,FALSE)*1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks