Excel: Getting frustrated with excel formula! Help!

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?

This question generated 29 answers. To proceed to the answers, click here.

This thread is current as of March 09, 2014.

For more resources for Microsoft Excel