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!!

Vlookup with dropdown dont popilate
Vlookup to find missing data in 2 columns - Excel Forum
Transfer data from one excel worksheet to another automatically vlookup ✓ - Excel Forum
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
Copy data from one Excel sheet to another: automatically - Guide

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

Change colour of range of cells based upon text from a drop down menu in another

Dropdown lists in excel 2007

Concanating text using vlookup forumula

Compare values in two columns and return the value from third

Conditional Formatting in a vlookup

Similar discussions

Subscribe To Our Newsletter!