Hi, I have my data which has a telephone number in. I need to do a lookup against the telephone number against my sample on another sheet to obtain name, address etc. However the sample sheet has three columns with three different telephone numbers (mobile; home; office). Therefore my original data needs to look up column A against column E,F,G in another sheet. It is only working against one of the columns.

Can a Vlookup look up a range of columns, or is it only one?

Thanks
Sam