Adding to an existing search

[meppwc]

The formula below resides in cell F3 and it works perfectly. If a "hit" is found in C2:C600 then the value in column C is displayed in F3
=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH(A3,$C$2:$C$600),$C$2:$C$600),"")

I am trying to figure out a way of it displaying the value from column B opposed to the value in column C

For example:
If cell B100 has a value of "black", and cell C100 has a value of "white"
The current formula will return "white" if a hit occurs in C100
I want it to return "black" if there is a hit in C100

Note - because of certain conditions I must continue to utilize the combination of LOOKUP and SEARCH.
Any assistance greatly appreciated.

 

[Yongle]

how about

=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH(A3,$C$2:$C$600),$B$2:$B$600),"")

 

[LloydFinancials]

=index(b:b,match(iferror(lookup(9.99999999999999e+307,search(a3,$c$2:$c$600),$c$2:$c$600),""),c:c,0))

 

[meppwc]

LOL..........I too just figured it out............so sorry to have been a bother but I thank you both for replying.