Ask Your Question

how to set vlookup function from drop down list?

asked 2016-09-29 15:39:35 +0200

Gigiux gravatar image

Dear all,

I set a drop down list in a cell, let's say A1 based on the range let's say C1:C12; each of the values in this range is associated to a value store in the range D1:D12. I then set another cell (B1) get a value from the range D1:D12 using the formula:


Now, this kind if approach works in excel, but in calc i get #N/A.

How can I sort it out?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-09-29 15:57:10 +0200

pierre-yves samyn gravatar image


May be I do not understand well, but use VLOOKUP(B1,C1:D12,2,0) in B1 should generate a Circular reference error.

I do not reproduce you problem with `VLOOKUP(A1,C1:D12,2,0)

See Vlookup.ods


edit flag offensive delete link more


sorry it was A1 actually: vlookup(A1, C1:D12,2,0). Both A1 and B1 look at the same data but B1 gives an answer based on the value that I can choose from the drop down list i set in A1.

Gigiux gravatar imageGigiux ( 2016-10-03 11:20:47 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-29 15:39:35 +0200

Seen: 487 times

Last updated: Sep 29 '16