Previous Topic Next Topic

Vlookup with dropdown dont popilate

Solved/Closed
Stormdronk - Aug 5, 2011 at 10:17 AM
 Stormdronk - Aug 5, 2011 at 11:31 AM
Hello,

I have a dropdownlist lets say in A1, in B1 I have a vlookup that looks up a range from A1 in a diferent sheet (=IF(E10="","",VLOOKUP(E10,'Capture Data'!R$5:S$54,4,FALSE))

The vlookup only finds the first dropdown, when I change the dropdown, the vlookup result dont change?

Would be grate if someone could help!!

1 response

Answer 1 / 1
Stormdronk
Aug 5, 2011 at 11:31 AM
To solve this problem you must set your calculations options to Automatic!!

On excel top baar, go to formulas, calculations options, automatic.

My settings were on manual

Found answere on internet.

Cool!!!!

Similar discussions

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response
Removing "FALSE" from an IF statement with a VLOOKUP
RayRay -
RayRay -

2 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Excel 2007 Using vlookup function in VBA
gsyrill -
gsyrill -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses