I'm sure this is an 'easy to fix' problem but I'm being a thicko.
I've attached a spreadsheet with six columns.
What I want is for it to take colmn D and match it with column A. Then if it finds a match put the corresponding line in column B and C into columns E and F.
GD10ELECMOD (at D4) is located at (A5) so it populates T1000 ELECTRICAL HARDWARE and MOD in columns E and F so it will sort all of column D out without me physically looking and copying and pasting.
Hope you can understand what I'm getting at?