Forum Discussion
Vlookup and copy from one sheet to other sheet the value is right aligned
In this the file the serial no is aligned right and the lookup is not working properly please guide us why this is happened
You may force it to text
=VLOOKUP(TEXT(C9, "General"),'Table Export'!$E$2:$W$234,8,FALSE)
You may force it to text
=VLOOKUP(TEXT(C9, "General"),'Table Export'!$E$2:$W$234,8,FALSE)
why are the serial No are left aligned?
By default texts are left aligned and numbers are right aligned.
Serial No has lot of texts, it's logically better to keep numbers, is they are, also as texts. Better to follow one column - one format, text or number one.