Lookup match index multiple values return other columns

Originally Posted by icestationzbra

i took the liberty to assume that only first_name and last_name need to be matched.

take a look at the attached.

Ok.... scrap my last post completly... I now have 2 new fields with pure data H and I

new sample attached

I need to match (A) first name and (C) last name - exactly with the data that is within (G) full name and return (F) phone number - this part solved - thankyou icestationzbra
If (B) middle name is present in (B) then I need to match it with what is within (G) - but won't necessarily always be in (B) even if it is in (G)

Because first and last names will have lots of matches and middle name won't always be there I also need to......

Make sure (H) suburb and (I) postcode matches with what is in (D) and (E) before returning (F) phone number


Hope this makes sense... what a headache!