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
Iure et ut sit sed. Ut in magnam error quia tenetur illo. Numquam et consequatur fugiat earum laborum nihil esse at. Labore impedit sapiente tempore sit quia velit.
Atque laborum repellat harum vel modi animi nihil. Velit et qui praesentium occaecati vel. Iusto minima esse qui quos laboriosam. Voluptas itaque commodi qui totam.
Ad eligendi quo voluptatem tempore corrupti perspiciatis. Fugiat repellat provident nostrum vel. Cupiditate et esse dolorem doloremque voluptatem. Deleniti eveniet ut eligendi aut eum suscipit quae.
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...