|I am developing a spreadsheet to track when a letter is sent by someone in my group for a specific company. The first Sheet "Sheet1" is my tracking sheet.|
I want to build a function that will look through all of the worksheets and find a specific company name for the correct column search.
For example this formula worked for a single worksheet. =VLOOKUP($B6,Cassaday!D$5:$S$300,1,FALSE)