Vlookup to add data to another tab

Copper Contributor

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

Screenshot 2020-03-25 at 15.26.53.png

 

 SF tab

Screenshot 2020-03-25 at 15.25.28.png

1 Reply

@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.