LinkBack URL
About LinkBacks
lordtopcat 
Thanks Paul, that's great!
I've had a mess around and it displays #/NA when there is nothing entered, can I change this?
Cheers.
Thanks Paul, that's great!
I've had a mess around and it displays #/NA when there is nothing entered, can I change this?
Cheers.
In 2007+ you can use:
=IFERROR(VLOOKUP(A1,Sheet1!$A$1:$B$800,2,0),"")
For compatibility with 2003 and earlier, use:
=IF(ISNA(VLOOKUP(A1,Sheet1!$A$1:$B$800,2,0)),"",VLOOKUP(A1,Sheet1!$A$1:$B$800,2,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks