serraostudent1
New Member
- Joined
- Nov 17, 2010
- Messages
- 45
I have the following formula working correctly! However it works correctly until it gets an error.
=iferror(vlookup(a2,a2:k450,6,0),"not in list")
Once the first "not in list " is returned
I need excel to start again by looking at the row above.
For example. Rows 2,3,4 all return column 6 correctly. Then Row5 was "not in list" excel should perform the above formula again but, start from row 4. Then loop until the end.
I hope this makes sense!
Thanks for taking the time to read my post!
Can you assist?
=iferror(vlookup(a2,a2:k450,6,0),"not in list")
Once the first "not in list " is returned
I need excel to start again by looking at the row above.
For example. Rows 2,3,4 all return column 6 correctly. Then Row5 was "not in list" excel should perform the above formula again but, start from row 4. Then loop until the end.
I hope this makes sense!
Thanks for taking the time to read my post!
Can you assist?