Ask Your Question
0

Calc: vlookup produces Er:502 error after column 10

asked 2018-05-04 22:38:02 +0200

Goc2 gravatar image

updated 2018-05-09 17:40:09 +0200

LibreTraining gravatar image

I am trying to post a value from a different sheet using Vlookup and a dropdown list.

=(VLOOKUP($A$15,cstmr,11,0))

The dropdown cell is A15. The sheet pulling the data from is cstmr. The column is 11.

The formula works up to and including column 10. From 10 on it produces ERR:502. I've checked cell format till blue in the face.

As a test I also eliminated columns before column 10 to confirm if the column which was 11 would work if it became 10. The result, it did not work. It tells me it is something column related.

Why would it work up to a certain column and not in any column after?

Any thoughts?

edit retag flag offensive close merge delete

Comments

1

Quoting @Goc2: "Any thoughts?"
Yes: You won't get an answer this way.
A helper to-be cannot even check if your cstmr actually is a named range and actually is containing at least 11 columns.
Please read https://ask.libreoffice.org/en/questi... and edit your question then in a way (adding the needed information!) allowing for a reasonable answer.
How should I check for "something column related" without knowing anything about the columns?

Lupp gravatar imageLupp ( 2018-05-05 11:06:25 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-05-09 16:37:57 +0200

Goc2 gravatar image

updated 2018-05-09 17:05:30 +0200

Lupp,

Your comment lead me to confirming the "named range". It appears the named range "cstmr" did not include the columns after column 10 and that's why it was returning an error.

I read the link you provided above to improve upon my future approach when posting.

Thank you Lupp.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-04 22:38:02 +0200

Seen: 225 times

Last updated: May 09 '18