Prev: Comment Edit
Next: Can multiple criteria be used for IF formulas?
From: Caroline on 25 Feb 2010 10:18
I have this function:
=VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2)
The lookup value is either 5655, WC 255 or WCP36.
The formula brings back the price of the lookup value. It does not bring
back the right price for WC 255 or WCP36 even though they are entered
correctly into the table. It does bring back the right price for the 5655.
Am I doing something wrong?

From: Niek Otten on 25 Feb 2010 10:43
=VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2,FALSE)

Look in HELP for the meaning of the 4th argument (FALSE)
--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Caroline" <Caroline(a)discussions.microsoft.com> wrote in message
news:8A25590D-5908-48AE-94A1-AFABA6492EB6(a)microsoft.com...
>I have this function:
> =VLOOKUP(S2,'MFD Cost Table'!$B$3:$C$13,2)
> The lookup value is either 5655, WC 255 or WCP36.
> The formula brings back the price of the lookup value. It does not bring
> back the right price for WC 255 or WCP36 even though they are entered
> correctly into the table. It does bring back the right price for the
> 5655.
> Am I doing something wrong?
>

 | 
Pages: 1
Prev: Comment Edit
Next: Can multiple criteria be used for IF formulas?