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.

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    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)
  • 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.

     

     

Resources