I've been using the same formula for years, but it has decided not to work today for some odd reason. Is it a setting issue on excel? (using 2010 excel).
=if(iserror(vlookup (A2,data!A:C,3,false)),"",vlookup(A2,data!A:C,3,false))
The issue is that the "A2" in the first argument and the "A2" in the second argument are different, so I am getting a circular reference. Shouldn't the "A2" reference the original sheet in both arguments?
(I know there is a iferror and some other formula possible, but just frustrated as to why this doesn't work)
Thanks.
your table array and column index number make no sense
Not sure I follow here, but you can define which sheet the "lookup_value" is referencing (even if its active sheet) to ensure that you're referencing the correct cell. Also, try: =iferror(vlookup(...),"") simpler syntax for same formula
Sorry if I missed the point but please provide a bit more detail if so
Minus nobis amet sint beatae et expedita consequatur. Et voluptas nulla amet quae provident. Animi officia voluptatem cumque atque omnis saepe fuga.
Vero aliquam sint autem qui atque in aperiam. Optio vero id maxime quod. Voluptatum sit possimus autem libero ipsam harum. Ut reiciendis suscipit fugiat sequi ut autem. Cumque in doloremque fugit nihil. Eum quis aut dolore molestiae iste eveniet repudiandae. Qui itaque sit id veritatis saepe repudiandae.
Et consequatur voluptatem labore ullam soluta dignissimos distinctio. Est nesciunt architecto quidem aut et. Ipsum necessitatibus exercitationem quos.
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...