LOOKINGUP IN 2 DIMENSIONS

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

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!
 
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
 
Back
Top