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?
| +102 | KISSED MY VP… HELP!!! | 16 | 1d |
| +27 | How expensive is SF? | 14 | 4d |
| +15 | Give me all your ideas | 2 | 16h |
| +9 | Morning or evening for gym time? | 12 | 12h |
| +9 | Your experiences with digital twins in industry? | 1 | 6h |
| +7 | Does SpeedX China Accelerator Really Work | 1 | 10h |
| 0 | What is a tool that you wish you had and would use every day? | 3 | 3d |
| 0 | ib with coc clan leader background? | 2 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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
Voluptas porro dolorem voluptatem quasi sint rerum. Sint aut tempore mollitia perspiciatis totam qui molestiae. Accusantium sit itaque et assumenda nemo quia earum. In dolores repudiandae dolores. Vel aut nisi minima sint. Architecto porro nihil ratione rerum vero. Esse aut expedita distinctio eum hic eius sint.
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...