Dropdown list and vlookup in combination

  • Thread starter Thread starter emilija
  • Start date Start date
E

emilija

I have following problem:
I use drop down list for entering data in some cells. In other cell I use
formula (VLOOKUP) and lookup_value is value from the list, but it is
happened that formula returns me some wrong data, same value in all cells,
no mater which value is in lookup_value cell.
Any tips, advice...
Thanks in advance, Emilija
 
Hi Emilija

i also do this in some worksheets without a problem, could you please post
back with a (plain text) example of the table you're looking up to & your
vlookup statement (2 examples please)

cheers
JulieD
 
Hi Emilija
best to post your VLOOKUP formula. One idea: did you use the 4th
parameter of VLOOKUP to return exact matches. e.g.
VLOOKUP(a1,data_range,2,FALSE)
 
Hi emilija

the problem is that the first column of the lookup table must contain the
lookup value, ie your lookup table should start at column C not B

- also change the column number
so your vlookup statement would now be

=VLOOKUP(Presmetka!B6,Materijali!$C$4:$E$200,2)

Cheers
JulieD
 
Hi Emilija
as I have guessed you have to add the forth parameter. Change the
formula
=VLOOKUP(Presmetka!B6,Materijali!$B$4:$E$200,3)
to
=VLOOKUP(Presmetka!B6,Materijali!$B$4:$E$200,3,FALSE)

P.S.: Don't attach files to this newsgroup. always post in plain text
(e.g. copy your formula). Most people won't open attached files
 
Hi Frank

i can't get it to work without changing the table array to start at column C
(and column #) .. .but yes, i agree, he should add the 4th parameter -
forgot to mention that in my post.

Cheers
JulieD
PS as we are on different sides of the world, i'm guessing one of us should
be in bed :)
 
Hi
just saw you also have to adapt the lookup range. Make this
=VLOOKUP(Presmetka!B6,Materijali!$C$4:$D$200,2,FALSE)
 
Hi JulieD
shee also should add the 4th parameter. e.g.
=VLOOKUP(Presmetka!B6,Materijali!$C$4:$E$200,2,0)

as the lookup range is not sorted
 
Hi Julie
just send a similar response to your post :-)
For me it's about 5 pm -> so enough time for me to go (though not so
sure about your time in Australia)
 
-----Original Message-----
I have following problem:
I use drop down list for entering data in some cells. In other cell I use
formula (VLOOKUP) and lookup_value is value from the list, but it is
happened that formula returns me some wrong data, same value in all cells,
no mater which value is in lookup_value cell.
Any tips, advice...
Thanks in advance, Emilija

Email me a copy of that spread sheet and am willing to
Click to expand...
take a look at it
(e-mail address removed)
 
I have a similar problem. I have a workbook, consisting of
2 sheets. Sheet 1 is called Blank Log, Sheet 2 is called
Lists. I have drop down lists installed on sheet 1 (Blank
Log). When I open the drop down lists, I would like to
have excel take me to the proper section of the list after
I type in just the first character or two. Since I am
pretty new to this, I have no idea what formula to use, or
even where to put that formnula. I would really appreciate
any help, as this has now become an obsession with me.
Thanks.
 
Back
Top