The Vlookup Function That Searches The Entire Workbook in Excel - UDF is fantastic and will prove useful, however, in this particular case, I need to add an IF statement and/or condition. I am searching for a value of a standard field for all sheets across multiple sheets and need to be able to make it only find the result if another field matches. Example, all worksheets have individual customer names in C2 and a score result for each period in D9 and potentially E9 with E being the most recent if available, otherwise D would be. I need to bring back the most recent score for a each customer on the summary page. I can't use the custome Vlookup because it will always find the score field on the first page and bring that result back regardless of the customer I am actually trying to search for. The amount of sheets varies each month so creating a list of them isn't really practical so if I can add IF statements, etc that would be perfect. The index match would be preferable for me as it is more flexible/customizable, but I'm not sure if I can change the UDF to use that forumla instead of Vlookup. Any suggestions?