Vlookup multiple conditions

[jenkins116]

hi there

i have attached a spreadsheet and trying to pull details from a main rota into individuals rotas, based on date and name. i have tried multiple conditions based on a few google searches but its not working. anyone able to point me in the right direction please.

[Ace_XL]

Switch to..

=INDEX(Sheet1!$A:$H,MATCH(D$2,Sheet1!$3:$3,0),MATCH($A$1,Sheet1!$A:$A,0))

[dilipandey]

Hi Jenkins,


Try using below formula:-

Please Login or Register  to view this content.

See attached:- rt test.xls

Regards,
DILIPandey

<click on below 'star' if this helps>