Forum Discussion

AnnaP530's avatar
AnnaP530
Copper Contributor
Aug 19, 2024

Vlookup error

 

The vlookup formula should be working but unfortunately it is not. It is giving me error and I think its because of the argument is a number saved as text - what can I do? I do not want to convert to the number, tried to save it as a text, but it is still not working.

Excel for web
  • Steve_SumProductCom's avatar
    Steve_SumProductCom
    Iron Contributor
    Aug 19, 2024

    AnnaP530 VLOOKUP looks for the value in the first column of the table_array (lookup range), so you may need to adjust yours. Your lookup range starts in A, which doesn't seem to contain the values that you are trying to look for.

     

     

  • m_tarler's avatar
    m_tarler
    Steel Contributor
    Aug 19, 2024
    I looks like you are looking for the Invoice number from column Q in column A instead of column C.
    You should be using C2:N25470 and then instead of 10 use 8 so
    =VLOOOKUP(Q2, C2:N25470, 8, 0)
    or use the new XLOOKUP
    =XLOOKUP(Q2, C2:C25470, J2:J25460)

Resources