I have a sheet named "Data" with range A2:A100 displaying names of candidates
and B1:K1 containing fields like Email, Telephone, Cell, Address etc.

Now, on the new sheet "Result" range A2:A50 displays names of few selected
candidates while B1:F1 consists fields of only few selected fields like Email
etc.

Any idea of a formula for Result!B2:F50 looking up in the Data sheet and
displaying the relevant info?

Thanx!

--

Best Regards,
FARAZ A. QURESHI