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
Ratione delectus nihil placeat exercitationem officia. Nostrum molestiae omnis quod eaque nostrum. Autem omnis perspiciatis suscipit est est. Vel velit odio voluptatibus provident non accusantium. Dolore cupiditate explicabo blanditiis occaecati tenetur.
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...