Hi All,
I have a list of transactions where there is multiple lines per reference, I also have a list of delivery charges where I currently have a lookup to pull this through to my list of transactions.
The problem is, because there are multiple lines for each reference the lookup is pulling through the delivery charge on each line. e.g. -
34PJ5F457FBF 18.35
34PJ5F457FBF 18.35
34PJ5F457FBF 18.35
35355F45B8DA 18.98
35355F45B8DA 18.98
At the moment I then go through each line and manually delete all but 1 delivery charge per reference. Is there a formula that looks at the reference and only does the vlookup on the 1st one?
Thanks
Bookmarks