INDEX or VLOOKUP + extra formula/value

[ricoandquesa]

Hi there

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

*Which one is better?

The only problem with both of these is that I can't refence a formula in another cell, I get a 0 value. The formula that I would like to reference relates to column D where the INDEX or VLOOKUP formula is located.

*Can either of them incorporate the following -

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Thank you Quesa

[shg]

Regarding the first issue, I prefer the second option for its brevity.

In the first option, the use of False as the match_type argument is spurious. The match_type enumerations are -1, 0, or 1 for match descending, exact, or ascending respectively.

Regarding the second issue, I can't guess what you're trying to do.

[ricoandquesa]

I have attached my spreadsheet.

See the cells r12-r18 need to give the same results as j12-j18, the same with r155 & j155.

At the moment I am getting a 0 value.

Thank you

[shg]

The formulas in J12:J18 return zero because the lookup result ('Call Rates'!C8) is zero. And that is zero because the precedent to its formula ('Call Rates'!D31) is blank.