Forum Discussion

tonyr1129's avatar
tonyr1129
Icon for Microsoft rankMicrosoft
Aug 06, 2020
Solved

What is this invisible data format?

Hello, I have received a data file where columns C,D,E (see image 1) have numbers in them. The data format shows as "General". However, when I do a lookup (vlookup/xlookup), it can't find a single ma...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 06, 2020

    tonyr1129 

    Not exactly, that's like

    =VLOOKUP([@[Current PartnerONE ID]],--FY20MPLoffboard!$A$2:$C$510,3,FALSE)

    alternatively

    =VLOOKUP([@[Current PartnerONE ID]],VALUE(FY20MPLoffboard!$A$2:$C$510),3,FALSE)
or
=VLOOKUP([@[Current PartnerONE ID]],1*FY20MPLoffboard!$A$2:$C$510,3,FALSE)
or like
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 06, 2020

tonyr1129 

Not exactly, that's like

=VLOOKUP([@[Current PartnerONE ID]],--FY20MPLoffboard!$A$2:$C$510,3,FALSE)

alternatively

=VLOOKUP([@[Current PartnerONE ID]],VALUE(FY20MPLoffboard!$A$2:$C$510),3,FALSE)
or
=VLOOKUP([@[Current PartnerONE ID]],1*FY20MPLoffboard!$A$2:$C$510,3,FALSE)
or like
tonyr1129's avatar
tonyr1129
Icon for Microsoft rankMicrosoft
Aug 06, 2020

SergeiBaklan These are really great examples. Thank you! The first suggestion that I edited also seems to work.