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?
| +95 | Are you “less ambitious” for having long term goals outside of NYC | 23 | 16m | |
| +57 | How to sound more eloquent? | 26 | 1d | |
| +40 | WSO Ranking On Resume??? | 10 | 2d | |
| +35 | Interviews Are So Fake | 23 | 5s | |
| +33 | 2024 UK Election - Tories finished? | 20 | 10h | |
| +29 | Being Christian in investment banking | 14 | 4h | |
| +26 | Is my boss gaslighting me? | 3 | 5d | |
| +22 | Ideas for things to do with a free semester before starting ft? | 9 | 1d | |
| +20 | Sabotaging Peers to Get Ahead? | 34 | 3d | |
| +19 | What's going on at Columbia? | 16 | 44m |
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
Autem et similique numquam reiciendis commodi perferendis. Dolor molestiae omnis enim officiis. Suscipit praesentium quia atque ab. Ut eius optio tempore sapiente. Nisi facere possimus exercitationem.
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...