vlookup two areas or one

[johny]

I need a formula to check the name in [a200]
and check to see if it is in this range(A11:A94) and range(BF11:BF94) Or attached
A11:Bf94. if it does find a match the cell is blank
and if it doesn't find a match it = a200 the name.
Thanks in advance Johny

 

[Aladin Akyurek]

On 2002-10-08 19:17, johny wrote:


I need a formula to check the name in [a200]
and check to see if it is in this range(A11:A94) and range(BF11:BF94) Or attached
A11:Bf94. if it does find a match the cell is blank
and if it doesn't find a match it = a200 the name.
Thanks in advance Johny

=IF(ISNUMBER(MATCH(A200,A11:A94,0)),"",IF(ISNUMBER(MATCH(A200,BF11:BF94,0)),"",A200))