Hi
In my file attached I want column L = column K from column M but bring up the value in column N , so basically it should look up the value in column M and bring the SPNAT code up from column N. Hopefully I made sense in what Im saying . Im not good at excel. Im obviously using the vlookup incorrectly.
Bookmarks