e.g.
so a1 has reference number and e:E also has the reference numbers but in columns f:F it has the date the customer signed the paper work.
So
if A1 says 101 it will search column E:E for 101 and finds it in e22 it will paste in B1 the data that is is in f22
Bookmarks