maximillianrg
Board Regular
- Joined
- Aug 7, 2014
- Messages
- 74
- Office Version
- 2016
- Platform
- Windows
Hello Excel Masters - Thank you for looking at my post
- Lets say I have the 3 excel sheets in the same folder called master.xls, aaa.xls, and bbb.xls
- In the file named master.xls I can write the following formula and if the data is there the formula works
=VLOOKUP(993161,[AAA.xlsx]Sheet1!$A$1:$B$5,2,FALSE)
Is it possible to write a formula that would look in sheet AAA for the value 993161 and if it existed, execute the above formula and if it did not would look in sheet BBB.xls?
- Lets say I have the 3 excel sheets in the same folder called master.xls, aaa.xls, and bbb.xls
- In the file named master.xls I can write the following formula and if the data is there the formula works
=VLOOKUP(993161,[AAA.xlsx]Sheet1!$A$1:$B$5,2,FALSE)
Is it possible to write a formula that would look in sheet AAA for the value 993161 and if it existed, execute the above formula and if it did not would look in sheet BBB.xls?
