janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 117
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I need to add a formula to this to remove ERRORS and bring them back as a BLANK. I tried putting it to the end of this formula, but it didn't work and gave me an error.
Not sure where to add in the formula to make it work. I always get stuck on how to order them and errors. Sigh.
=IF(Q333="","",IF(AE333="",VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE)))
Not sure where to add in the formula to make it work. I always get stuck on how to order them and errors. Sigh.
=IF(Q333="","",IF(AE333="",VLOOKUP(Q333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),VLOOKUP(AE333,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE)))