Sorry if my English bad, im from Indonesia!
we try to lookup data from another sheet but the data displayed is always different, for example:
LOOKUP([NIP Pembimbing Pertama].[Nama Dosen Pembimbing Pertama], “Sheet2”, “Nama”, “NIP”)
Data on Sheet2 NIP is 196009291987031002 but result LOOKUP show 196009291987031000
Why? I just need original value…
it should end in 002 not 000