I keep getting and invalid data type error for my VLOOKUP formula

I have to sheets in my workspace, one contains system generated authorization numbers, and the other tracks requisitions. I want to populate the credit card authorization numbers from one sheet onto the requisition tracking sheet. I am using the following formula. The value returned is a combo of number and text. The requisition number is the primary value on both sheets. Is the fact that the value I am trying to return is system generated causing an issue?

=VLOOKUP([Requisition Number]@row; {CPC AUTHS Range 1}; 4)

Best Answer


  • Sam M.
    Sam M. ✭✭✭✭✭

    Hi Yvette,

    I might be wrong, but did you use this formula exactly?

    =VLOOKUP([Requisition Number]@row; {CPC AUTHS Range 1}; 4)

    if so, try changing the ";" to "," that might be causing an error of #UNPARSEABLE.

    The formula would end up like this:

    =VLOOKUP([Requisition Number]@row, {CPC AUTHS Range 1}, 4)

    You can also try:

    =VLOOKUP([Requisition Number]@row, {CPC AUTHS Range 1}, 4,false)

    If it does not work, please let me know the error that it gives you.

    Hope it helps!


  • Yvette
    Yvette ✭✭✭

    Now it is saying incorrect argument

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    FOr the Incorrect Argument Error, double check your range to ensure it has at least 4 columns included with the first column be the column that houses the data to match on.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!