LinkedIn
Twitter
Hello,
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
Solved
1 ACCEPTED SOLUTION
I have just made a test with google sheet. The result is the same as previous test, however, I found that when test using expression assistance, it shows the correct number. as below snapshot. However, in the emulator and google sheets, when the type selected is number, it shown with truncated number (after the 15 digits).
Btw, @Bihikmi_ptn, you may jump-in with questions if you haven’t found the solution to your issue.
