You could use a MATCH function which returns the row in a range instead of
the value, then you would combine it with an INDEX function to select the
proper column. Something like:

=IF(FREQUENCY(...)1, INDEX(myRangeToSearch, MATCH(mySoughtValue,
myColumnRangeToMatch, 0), myColumnNumber), VLOOKUP(...))

=INDEX(A8:B11,MATCH("123456",A8:A11,0),2)

Stephane Quenson

--
Message posted via http://www.officekb.com