Can anyone please let me know how I can use a lookup formula to search through several excel sheets inside a workbook? thanks.
