V Lookup using 2 criteria

F

fergal

I have a table with col headings week no and row headings no of
trainees. I am trying to write a table look formula that will take
the number of trainees from one cell and the no of weeks in training
from another cell and find the intersection value on the table.

If your confused imagine how I feel. I'm sure its possible but maybe
not in the way I have explained. I have a certain amount of licence
to change the layout or procedure if deemed to be better.

Rgds
Fergal
 
J

JS

Hi,



Index and Match functions should do this for you - something like below:



=INDEX(B2:D4,MATCH(C6,A2:A4,0),MATCH(D6,B1:D1,0))



B2:D4 is the range for the data in your table not including row & column
headings

A2:A4 is the row headings range for Trainee No

B1:D4 is the column headings range for No. Weeks

C6 & D6 are the cells where you type trainee no. and week



Change the formulas to fit your spreadsheet
 
Top