LinkBack URL
About LinkBacks
=IF(AND(C13<>"Banked Hours (J)",A7=VLOOKUP(A7,Data!Q2:Q36,1,FALSE)),"Unpaid (M)"," ")
This returns #N/A if the Name in A7 is not in my Vlookup list on my data list (Data!). I just want it to be blank. What am I missing here?
Thanks!
=IF(AND(C13<>"Banked Hours (J)",A7=VLOOKUP(A7,Data!Q2:Q36,1,FALSE)),"Unpaid (M)"," ")
This returns #N/A if the Name in A7 is not in my Vlookup list on my data list (Data!). I just want it to be blank. What am I missing here?
Thanks!
try wrap it with iferror
=IFERROR(IF(AND(C13<>"Banked Hours (J)",A7=VLOOKUP(A7,Data!Q2:Q36,1,FALSE)),"Unpaid (M)"," "),"")
Perhaps the IFERROR part..?Originally Posted by MrsRobinson
=iferror(IF(AND(C13<>"Banked Hours (J)",A7=VLOOKUP(A7,Data!Q2:Q36,1,FALSE)),"Unpaid (M)"," ");"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Clunk...I pulled it out when other cells factored in...never thought to put it back in. thanks so much!!!
Vlookup isn't really the best funtion for the task of checking if a value exists in another column..
Try
COUNTIF(Data!Q2:Q36,A7)>0
This way, Countif doesn't error if the value doesn't exist at all, so no need for iferror
=IF(AND(C13<>"Banked Hours (J)",COUNTIF(Data!Q2:Q36,A7)>0),"Unpaid (M)"," ")
Clunk...I pulled it out when other cells factored in...never thought to put it back in. thanks so much!!!
Jonmo1 & Fotis - thanks to both - both solutions work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks