Mar 25 2020 07:58 AM
Hello,
I am trying to copy the account id data from the account ID tab to the SF tab. But my Vlookup formula returns #n/a =VLOOKUP(A2,'Account ID'!A:B,2,FALSE)
What I am doing wrong ?
Thank you
AccountID
SF tab
Mar 25 2020 08:18 AM
@hermy1 One of your sets of network IDs is formatted as text. To fix, type a 1 in a cell not formatted as text, copy it, select the column, and Paste Special => Multiply.