Vlookup error

[AnnaP530]

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.

[#2]

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

[#3]

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)