I have a speadsheet which is currently set up to enter a value in column A based on the text in Column G - unless the text in column G is 'complete', 'blocked' or 'duplicate', in which case the related cell in column A remains blank.
I am using the following IF statement which references a worksheet called 'vlookup':
=IF(G33="complete"," ",IF(ISNA(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))," ",IF(G33="BLOCKED"," ",IF(ISNA(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))," ",IF(G33="duplicate"," ",IF(ISNA(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))," ",(VLOOKUP(D33,Vlookup!$G$3:$H$152,2,FALSE))))))))
This does work but I wondered if there is a simpler way of doing this.
Thanks
Glayva
Bookmarks