I currently have the following formula which is saying that I've entered too few arguments for this function.
How would I go about fixing it? Is there an easier way?
=IF(AND(VLOOKUP('TAB1'!C2:C500=1,'TAB1'!D2:D500="yes"),"in use","available")
I want it to check the TAB1 sheet in column C to...