I am trying to match some data and want to know if i can use a formula to do this.
From the image attached, i want to use the data in Column N, to match against Column A, to populate Column H with data from Column O.
Eg, to populate H2, Z_GB_0001 is matches the 1st part of A2 (Z_GB_0001_ST005) so therefore H2 would populate with the data in O2.
Thanks
Andy
Bookmarks