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

Try this in B2:

=INDEX(Data!$B$2:$K$100,MATCH($A2,Data!$A$2:$A$100 ,0),MATCH(B$1,Data!$B
$1:$K$1,0))

Copy across and down as required.

Hope this helps.

Pete

On Dec 18, 11:19*am, FARAZ QURESHI
wrote:
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