Hi every body

i am trying to lookup a unique value in 6 different workbooks, i tried the
following argument,
=IF(ISNA(VLOOKUP($A:$A, Sheet2!$A:$B, 2, FALSE)), VLOOKUP($A:$A,
Sheet3!$A:$B, 2, FALSE), VLOOKUP($A:$A, Sheet2!$A:$B, 2, FALSE)),
but it works with two different workbooks/sheets, but i have 6 different
workbooks,

pleaaaaaaaaaze help of think to use some thing else to get same result

i tried to put AND/OR, but i failed to get it work.
thanks

I would put the 6 lookups in separate cells, say A1:F1, and then use


=IF(COUNTIF(A1:F1,"#N/A")<6,INDEX(A1:F1,,MIN(IF(NOT(ISNA(A1:F1)),COLUMN( A1:F1)))),"none
matched")

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"T_Hawary" wrote in message
...
Hi every body

i am trying to lookup a unique value in 6 different workbooks, i tried the
following argument,
=IF(ISNA(VLOOKUP($A:$A, Sheet2!$A:$B, 2, FALSE)), VLOOKUP($A:$A,
Sheet3!$A:$B, 2, FALSE), VLOOKUP($A:$A, Sheet2!$A:$B, 2, FALSE)),
but it works with two different workbooks/sheets, but i have 6 different
workbooks,

pleaaaaaaaaaze help of think to use some thing else to get same result

i tried to put AND/OR, but i failed to get it work.
thanks