Hi,
try
You have the value to lookup in cell D2, values in column A from row 1 to 4,
and the information to put together in rows B and C

=IF(SUMPRODUCT(--(D2=A1:A4)),B1:B4&C1:C4)

change range to fit your needs

"Hugh self taught" wrote:

Hi All,

Vlookup in it's basic usage is no problem for me but now I need to lookup a
matching value in column 2 & return the values of columns 3 & 4. Preferably
in the format of xxxxxxx & yyyyyyyy since columns 3 & 4 are names.

If you could help with any method that is simple & works would be great.

Cheers
Hugh