I have a number of tables in my workbook on different sheets. I want to search all of these tables for a value and then return the value adjacent/to the right.
I have used a nested IF statement but it keeps returning value error.
Unsure which formula is best to use?
Bookmarks