itsgrady
Board Regular
- Joined
- Sep 11, 2022
- Messages
- 115
- Office Version
- 2021
- Platform
- Windows
- MacOS
Should be simple but I am having a difficult time putting two lookups in one cell to work in finding the information. If the first range does not have the information then the second range should have it. I will also need to add another range at a later date. Below are the two formulas I would like to add together in one cell:
IF(C25=“”,””,VLOOKUP(C25,’Sheet1’!$A:$G,2,False))
Or
IF(C25=“”,””,VLOOKUP(C25,’Sheet2’!$C:$D,2,False))
Thanks for the help.
IF(C25=“”,””,VLOOKUP(C25,’Sheet1’!$A:$G,2,False))
Or
IF(C25=“”,””,VLOOKUP(C25,’Sheet2’!$C:$D,2,False))
Thanks for the help.