Multiple VLOOKUP stump

[Sean15]

Hi:

Could you tell me why this formula is returning ""

=IF('LReports'!J3="UG",VLOOKUP(H3,'AVERAGE Price'!$B$5:$D$39,3,0),IF(J3="DF",VLOOKUP('LReports'!H3,'AVERAGE Price'!$B$5:$D$39,2,0),""))

VLOOKUP range looks something like this:

column B column C column D
MMYY DF UG
917 1.8954 1.7754
1017 1.8804 1.6722
1117 1.9728 1.7295

values in J are "DF", "UG" and No code

values in H: 917, 1017, 1117...


Thanks for your help.

Sean

 

[Sean15]

@Aladin Akyurek - trailing spaces were the issue. Thank you very much for your help.


Regards,

Sean

 

[Aladin Akyurek]

@Aladin Akyurek - trailing spaces were the issue. Thank you very much for your help.


Regards,

Sean

You are welcome.

 

[Sean15]

@Aladin Akyurek - one last question.

In VLOOKUP(J3,{"DF",2;"UG",3},2,0)

What is the purpose of the second 2?

 

[Aladin Akyurek]

@Aladin Akyurek - one last question.

In VLOOKUP(J3,{"DF",2;"UG",3},2,0)

What is the purpose of the second 2?

{"DF",2;"UG",3} is a hard-coded 2-column table. Its first column consists of DF and UG, its second column 2 and 3. The second 2 in the formula refers to that column like the 2 in VLOOKUP(J3,TABLE,2,0) also does.​