Help with repeating returned values using index match

I am having to do a lookup against two sets of data and pull over information specific information from a column when there's a match. Typical index match usage really.   My formula works fine as i...