Hi all,
Trying to write a formula but getting stuck.
I have a list of around 30 items that are "Not Despatched". This list changes and I want to pull the updated list (which may be in different row numbers as time goes by, and there may be greater or fewer lines).
I tried VLOOKUP however...