vlookup question, should be easy

[rob36]

Hey, I have a quick question regarding a formula I want to use that is using the vlookup command.

currently in the cell I have this:

=X6/VLOOKUP(W6,'PNR Productivity Targets'!$D$5:$E$254,2)

where X6 is a number, and W6 is text which has different options listed on a drop down tab.

PNR Productivity targets D column has the different option listed in W6 listed out (I actually use the D column to reference the drop down options in W6), and the E column has a number associated with each of the options.

I am trying to get it so that based upon the option chosen, X6 will divide by different numbers according to the value I assign for eah option in the productivity targets page...

When I attempt this, even if I have a word that should be an exact match, If I used FALSE in my Vlookup I always get #NA.

It seems like its working sometimes (such as right now of course...), but is there anything that I may need to do? I thought there was something like putting something in {} brackets, or pressing shift + enter or something like that...

thanks in advance

 

[T. Valko]

Hey, I have a quick question regarding a formula I want to use that is using the vlookup command.

currently in the cell I have this:

=X6/VLOOKUP(W6,'PNR Productivity Targets'!$D$5:$E$254,2)

where X6 is a number, and W6 is text which has different options listed on a drop down tab.

PNR Productivity targets D column has the different option listed in W6 listed out (I actually use the D column to reference the drop down options in W6), and the E column has a number associated with each of the options.

I am trying to get it so that based upon the option chosen, X6 will divide by different numbers according to the value I assign for eah option in the productivity targets page...

When I attempt this, even if I have a word that should be an exact match, If I used FALSE in my Vlookup I always get #NA.

It seems like its working sometimes (such as right now of course...), but is there anything that I may need to do? I thought there was something like putting something in {} brackets, or pressing shift + enter or something like that...

thanks in advance

See this for descriptions of common data problems that lead to formula problems:

http://contextures.com/xlFunctions02.html#Trouble