I need to create a formula that has three lookup criteria. I have one source document, called "Sales Force". I want to know if the value in A1 is in column AA of Sales force tab, if not, then look for the value in A3 in the sales force tab, if still nothing, then look for the value in A5 in the sales force tab, otherwise, enter zero.
What do you want to return if the value is found?
Since you only look in one column, Vlookup is not required.