The data to be returned is Text.

thanks

"T. Valko" wrote:

Also, is the value to be returned a number or text?

Biff

"T. Valko" wrote in message
...
Do you mean that the lookup_value could be in either columns B&C or F&G or
none?

It's not just in either column B or column F?

Biff

"Ram" wrote in message
...
Hi,

I'll give you an idea of the file that i am working on

Sheet 1:
Cell B2 has numeric data ex: 39022

Sheet 2:
Column B, C & D; F,G & H have data upto 50 rows

Destination cell for the formula is Sheet1!B3

What i need the formula in Sheet!B3 to do:

search for the value from Sheet1!B2 in Sheet2!B:C and if value exists
then
return value from column D;
if value does not exist in B or D, then search in columns F & G, if
exists
then return value from H.

If value does not exist in either B:C and F:G, then return blank

It has been very challenging for me to solve this. I manage to look up
using the look up function (vector), however i couldnt figure out, how to
integrate the condition.

Please let me know if you require more input from me.

regards,