|
LOOKINGUP IN 2 DIMENSIONS
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 |
LOOKINGUP IN 2 DIMENSIONS
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 |
| All times are GMT +1. The time now is 04:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com