I have a VLOOKUP formula, which, so far as I can tell, is formatted correctly:

=IF(E$376=VLOOKUP($B$366,'Model Inputs'!$B$3:$M$18,11),"BAU starts","")

But it's not returning the correct answer. When I manually look for the
value in B366 in the Model Inputs tab in the range B3:M18, and go over 11
columns I should find the value 11/30/2007, however, it's returning 7/31/2007.

Now there is another VLOOKUP formula in this workbook, which DOES return
7/31/2007, correctly, and which I copied to use for this second VLOOKUP.
However, I have changed the cell references in this copied formula. Yet it's
still returning the 7/31/2007 value.

Calculation is set to automatic. Am I missing something here? If I copy a
VLOOKUP formula, paste it somewhere else, and then change its cell
references, it should pick up a different value, not the value in the
original VLOOKUP, correct?
--
Brevity is the soul of wit.

Well I answered my question...the lookup table is not sorted alphabetically,
so adding the FALSE argument returns the correct value.

Duh.
--
Brevity is the soul of wit.


"Dave F" wrote:

I have a VLOOKUP formula, which, so far as I can tell, is formatted correctly:

=IF(E$376=VLOOKUP($B$366,'Model Inputs'!$B$3:$M$18,11),"BAU starts","")

But it's not returning the correct answer. When I manually look for the
value in B366 in the Model Inputs tab in the range B3:M18, and go over 11
columns I should find the value 11/30/2007, however, it's returning 7/31/2007.

Now there is another VLOOKUP formula in this workbook, which DOES return
7/31/2007, correctly, and which I copied to use for this second VLOOKUP.
However, I have changed the cell references in this copied formula. Yet it's
still returning the 7/31/2007 value.

Calculation is set to automatic. Am I missing something here? If I copy a
VLOOKUP formula, paste it somewhere else, and then change its cell
references, it should pick up a different value, not the value in the
original VLOOKUP, correct?
--
Brevity is the soul of wit.

Sometimes we can't see the forrest, because there is too many trees in the
way....

btdt

"Dave F" wrote:

Well I answered my question...the lookup table is not sorted alphabetically,
so adding the FALSE argument returns the correct value.

Duh.
--
Brevity is the soul of wit.


"Dave F" wrote:

I have a VLOOKUP formula, which, so far as I can tell, is formatted correctly:

=IF(E$376=VLOOKUP($B$366,'Model Inputs'!$B$3:$M$18,11),"BAU starts","")

But it's not returning the correct answer. When I manually look for the
value in B366 in the Model Inputs tab in the range B3:M18, and go over 11
columns I should find the value 11/30/2007, however, it's returning 7/31/2007.

Now there is another VLOOKUP formula in this workbook, which DOES return
7/31/2007, correctly, and which I copied to use for this second VLOOKUP.
However, I have changed the cell references in this copied formula. Yet it's
still returning the 7/31/2007 value.

Calculation is set to automatic. Am I missing something here? If I copy a
VLOOKUP formula, paste it somewhere else, and then change its cell
references, it should pick up a different value, not the value in the
original VLOOKUP, correct?
--
Brevity is the soul of wit.