# VLOOKUP not working

#### Excel Enthusiast

##### Member
Dear Sir, I'm trying to make a consolidated sheet which has School Fees dues from the previous years also. But the VLOOKUP is not working. Please help on this ASAP. As i have to start calling for the Dues payments from Monday.

Thanking You.
Pritpal Singh

#### Attachments

• 23.8 KB Views: 8

#### vletm

##### Excel Ninja
Excel Enthusiast
VLookUp ... works well!
... but ...
Your I-column formula's range containing the lookup value refers from B-column and the column number in the range containing the return value refers don't refer to H-column.
Same kind of challenge is with J-column formula ... please... check lookup value too.

You should learn to check syntax,
instead of copy and paste replies.

SYNTAX:
=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).
Your ASAP seems to be over

#### p45cal

##### Well-Known Member
cell I2:
=VLOOKUP([@Name],'19_20_Copy'!B:H,7,FALSE)
or:
=VLOOKUP([@Name],Table5[[Name]:[2019_Due]],7,FALSE)

cell J2:
=VLOOKUP([@Name],'20_21_Copy'!B:H,7,FALSE)
or:
=VLOOKUP([@Name],Table6[[Name]:[Due Amount]],7,FALSE)

#### Excel Enthusiast

##### Member
Excel Enthusiast
VLookUp ... works well!
... but ...
Your I-column formula's range containing the lookup value refers from B-column and the column number in the range containing the return value refers don't refer to H-column.
Same kind of challenge is with J-column formula ... please... check lookup value too.

You should learn to check syntax,
instead of copy and paste replies.

SYNTAX:
=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).
Your ASAP seems to be over
Yeah, i have stopped using ASAP lately, as you guys always help me out quickly. . Anyways thanks for your valuable advice again. Actually the problem was in the first column, vlookup works well when i exclude column A.
Thanks Again.

#### Excel Enthusiast

##### Member
cell I2:
=VLOOKUP([@Name],'19_20_Copy'!B:H,7,FALSE)
or:
=VLOOKUP([@Name],Table5[[Name]:[2019_Due]],7,FALSE)

cell J2:
=VLOOKUP([@Name],'20_21_Copy'!B:H,7,FALSE)
or:
=VLOOKUP([@Name],Table6[[Name]:[Due Amount]],7,FALSE)
Thanks a lot for your help, But i would like to know why VLOOKUP doesn't work when i select range containing the lookup value from A:H. ???

#### vletm

##### Excel Ninja
Excel Enthusiast
ASAP
You're wondering why VLOOKUP doesn't work ...
As everywhere even Excel -functions has rules.
Seems You skipped my given syntax.
Basically, Your question is same as
if 2 + 3 = 5
but why 2 x 3 = 6?