DavidLloyd100
New Member
- Joined
- Jan 28, 2009
- Messages
- 14
Hi
Im using the following formula vlookup(D6,'Nav Data'!$D$7:$H$82,2,FALSE) but i would like it that if the formula retirns #N/A the cell is blank. Does anyone now how does do this?
Any help much appreciated !
Cheers
cHRIS
Im using the following formula vlookup(D6,'Nav Data'!$D$7:$H$82,2,FALSE) but i would like it that if the formula retirns #N/A the cell is blank. Does anyone now how does do this?
Any help much appreciated !
Cheers
cHRIS