janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 117
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I am trying to squeeze in another two formulas into this one, but keep getting an error. I need to add a formula to bring back BLANK if it's an error, and also to bring back a BLANK if the lookup (Q426) field is blank. It keeps telling me too many arguments. The formula currently is:
=IF(AD426="",VLOOKUP(Q426,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),VLOOKUP(AD426,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE))
Please help.
=IF(AD426="",VLOOKUP(Q426,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE),VLOOKUP(AD426,'Radford (All US)'!$L$8:$HZ$9074,5,FALSE))
Please help.