Sparta_leadhead
New Member
- Joined
- Jul 13, 2008
- Messages
- 6
Hey guys.
I have a Vlookup as follows:
=VLOOKUP(M5,'Hits on Portal'!A4:D145,3,FALSE)
This searches for a certain name in a list, and returns a value in column 3 (a number), which works fine.
The problem comes when the name im looking for is not in the table the Vlookup searches, and returns #N/A.
How can i nest an IF fucntion to the formula above so that if the value returned from the Vlookup is #N/A, it is change to 0.
Thanks in advance
I have a Vlookup as follows:
=VLOOKUP(M5,'Hits on Portal'!A4:D145,3,FALSE)
This searches for a certain name in a list, and returns a value in column 3 (a number), which works fine.
The problem comes when the name im looking for is not in the table the Vlookup searches, and returns #N/A.
How can i nest an IF fucntion to the formula above so that if the value returned from the Vlookup is #N/A, it is change to 0.
Thanks in advance