In book #1, I have a pulldown menu with the validations on the same sheet. Pretend the pulldown is in cell A1. I can easily go to A2 and have it " =A1" and that works without errors.
I would like to display the pulldown results in book #2, but it's giving me #VALUE errors. how do i fix this?
You are just trying to get the value of A1 into the other book? So in Book2 you have a cell with the formula =[Book1]Sheet1!$A$1 And it's giving you an error?
I don't see why the value in A1 coming from a pulldown menu would affect your ability to reference the value in the cell.
If you are trying to get Book2 to have a matching pulldown that is a different issue.
Can you try to recreate the problem in otherwise blank worksheets that you could upload or describe it in more detail?
Yes, it's giving an error because it's some "validation field" or whatever that is pulling from a table from colujmn B. If i don't get an answer in 24 hours i'll upload an example
Est eos quasi modi quas. Iste et nesciunt et. Ab itaque non inventore. Non et maxime modi aut non qui enim.
Sed et repellat tempora asperiores itaque placeat. Dolorem asperiores quibusdam quam et quam quia consequatur. Consectetur voluptatum optio porro nihil. In error fugit eum. Aliquid doloremque dolorem id ut quaerat.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...