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:
VLOOKUP(B1,C1:D12,2,0)
Now, this kind if approach works in excel, but in calc i get #N/A.
How can I sort it out?
Tx
Hi
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
Regards
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.