complex vlookup to index match

[thedeadzeds]

Guys, is there a way to change the v lookup part of the below formula to an index match so i dont have to keep changing the column index on the v lookup?

=IFERROR(IF($AN$3<>"",VLOOKUP(Summary!$AN$3,Tracker!$H:$NI,4,FALSE),IF(ISBLANK(INDEX(Tracker!$G$4:$NI$42,MATCH(Summary!$AN$2,Tracker!$G$4:$G$42,0),MATCH(Summary!J5,Tracker!$G$4:$NI$4,0))),"",INDEX(Tracker!$G$4:$NI$42,MATCH(Summary!$AN$2,Tracker!$G$4:$G$42,0),MATCH(Summary!J5,Tracker!$G$4:$NI$4,0)))), "")

 

[Aladin Akyurek]

What is the header of column 4 in Tracker!$H:$NI?

 

[thedeadzeds]

Hi

Tracker!$H:$NI is as below:

A1

B1

C1

D1

E1

F1

G1

H1

I1

J1

K1

L1

M1

N1

O1

P1

Q1

A2

Total

0

0

2

2

1

1

0

0

0

A3

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Sun

Mon

A4

Key

Name

Team

01/01/2017

02/01/2017

03/01/2017

04/01/2017

05/01/2017

06/01/2017

07/01/2017

08/01/2017

09/01/2017

A5

Bethan Mason

Blue

A6

Full Day Sick

S

Ceri O'Sullivan

Blue

A7

Half Day Sick

s

Fran Miguel

Blue

S

S

A8

Full Day Holiday

H

Hannah Collins

Blue

H

H

H

H

A9

Half Day Holiday

h

Jodie Chivers

Blue

A10

Maternity Leave

M

Natasha Borowski

Blue

A11

Paternity Leave

P

Nicole Foxwell

Blue

A12

Unpaid Full Day

U

Sonia Pingue

Blue

A13

Unpaid Half Day

u

Charlotte Hanlon

Blue

A14

Authorised Paid Full Day

AF

Debi Card

Blue

A15

Authorised Paid Half Day

Ah

Joanne Seymour

Blue

A16

Training Full Day

T

Lewis Williams

Blue

A17

Training Half Day

t

Lorna Young

Red

A18

Louise Beamand

Red

<colgroup><col span="2"><col><col span="3"><col><col><col span="9"></colgroup><tbody>
</tbody>

 

[Aladin Akyurek]

What do we have in AN3, AN2, and J5 of Summary? Also, care to clarify why VLOOKUP operates on H:NI while INDEX\MATCH on G:NI?