Multiple Criteria Pickup
 

Hi All,

having a bit of trouble trying to get excel to pick up text in one sheet (sheet 2) and populate cells in another (sheet 1) if the row (row 1) labels and columns (column a) in both sheets match. hope that makes sense? many thanks in advance

Hi all tried Index-match as well, to no avail