Hi all hoping someone can help.
I need to do a vlookup, column e contains a product code e.g.1234567.
In sheet 2 i have the relevant product code in Column B what my code is eg.hbis05ss.
I need for excel to lookup what has been ordered (1234567) and tell me what my code is.
I hope that makes sense many thanks in advance.