I'm having issues trying to figure out how to substitue populate an "x" when I do a lookup
I've tried a few and nothing seems to work
=IF(MATCH($A2,[Book3]Sheet1!$A$2:$A$13,0),"x","")
=IF(VLOOKUP($A2,[Book3]Sheet1!$A$2:$A$13,1,FALSE),"x","")
=IF(LOOKUP($A2,[Book3]Sheet1!$A$2:$A$13),"x","")
None of these seem to work....
any ideas?
I've tried a few and nothing seems to work
=IF(MATCH($A2,[Book3]Sheet1!$A$2:$A$13,0),"x","")
=IF(VLOOKUP($A2,[Book3]Sheet1!$A$2:$A$13,1,FALSE),"x","")
=IF(LOOKUP($A2,[Book3]Sheet1!$A$2:$A$13),"x","")
None of these seem to work....
any ideas?