VLOOKUP function in Excel

[RVFmal]

Is it possible to use the VLOOKUP function in Excel to look for an exact value across more than one sheet in a workbook and possibly across more than one workbook?

 

[Emjay]

That should be a rather complicated function. I have used VLOOKUP before and I am certain that this cannot be done.

 

[RVFmal]

Hmm, it is simpler than I thought. Apparently this will assist:

=IF(ISNA(VLOOKUP(A1,FirstRange,2,false)),VLOOKUP(A1,SecondRange,2,false),VLOOKUP(A1,FirstRange,2,false))

Only downside would be that it will stop searching on the first match.

 

[jackgopher]

Vlookup always stops searching after the first exact match. If you want to know how many matches it finds, you can try using in a similar way with the countif function (but instead of using ISNA you should check if it equals to 0).

 

[feo]

2005