I want to be able to query multiple worksheets for a piece of information. If I can’t find a value via index/match function on worksheet A, what function do I use to search via index/match sheet B, if not on sheet B, then sheet C, and so on and so forth? What sort of functions would I use to do this (IF, THEN, etc)? I am relatively new to more advanced features of excel like this. Thanks in advance!
Webb