=IF(VLOOKUP(B20,C13:C19,1,FALSE),"Duplicate","OK")
i get #NA instead of "OK" when "Duplicate" is not applicable
Try:
=IF(ISNA(VLOOKUP(B20,C13:C19,1,FALSE)),"OK","Duplicate")
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
i want to fix hyperlink of powe point slide with particular cell of excel sheet for example
slide 2 of ppt hyperlink with cell A2 of Sheet1
Please start a new thread with your new question. Was your previous question solved ?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks