Forum Discussion
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 c...
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)
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)