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?
| +78 | People who despise the industry you work for - uncomfortable date story | 31 | 3m |
| +58 | Broke up with college gf before analyst role | 31 | 1d |
| +17 | Cardone Capital…..Crashout | 7 | 2h |
| +13 | WC Final: Spain v. Argentina | 17 | 3d |
| +6 | London Roommate Thread | 2 | 5d |
| +6 | Things to do in Charlotte before Tame Impala | 3 | 1d |
| +5 | Masters tickets lottery | 4 | 1d |
| +3 | Best Uber Eats Restaurants Toronto | 0 | 2d |
| +2 | Fire @ Jeff Building | 4 | 5d |
| +1 | Old Finance Blog - Going Private | 3 | 4d |
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
Qui harum quam error tempora. Temporibus corrupti quidem aperiam saepe facere. Qui sit odit libero accusantium sit alias. Aut voluptatem qui quo nisi assumenda magni quis nihil. Qui vitae et qui illo. Accusamus quia dolorem et autem.
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...