Ben_Holmes
Board Regular
- Joined
- Mar 30, 2004
- Messages
- 147
Hi,
I am using the following formula.
=VLOOKUP(BG5,Period105!$B$7:$E$1500,2,FALSE)
However if the formula returns #N/a I would like it to say no return.
How do I do this.
Thanks
Ben
I am using the following formula.
=VLOOKUP(BG5,Period105!$B$7:$E$1500,2,FALSE)
However if the formula returns #N/a I would like it to say no return.
How do I do this.
Thanks
Ben