"Dave Peterson" wrote...
You could use lots (4-5) =vlookup()'s in your formula:

=IF(ISNUMBER(MATCH(A1,Sheet2!A:A,0)),VLOOKUP(A1,S heet2!A:C,2,FALSE),
IF(ISNUMBER(MATCH(A1,Sheet3!A:A,0)),VLOOKUP(A1,She et3!A:C,2,FALSE),
IF(ISNUMBER(MATCH(A1,Sheet4!A:A,0)),VLOOKUP(A1,She et4!A:C,2,FALSE),
IF(ISNUMBER(MATCH(A1,Sheet5!A:A,0)),VLOOKUP(A1,She et5!A:C,2,FALSE),
"missing from all sheets"))))

(all one cell)

You are limited by 7 nested functions, though.
....

A variation on this would allow searching through 65535 worksheets. Enter a
list of worksheets in a single column, multiple row range and name that
range WSLST. Then use the array formula

=IF(SUMPRODUCT(COUNTIF(INDIRECT("'"&WSLST&"'!A:A") ,A1)),
VLOOKUP(A1,INDIRECT("'"&INDEX(WSLST,MATCH(TRUE,
COUNTIF(INDIRECT("'"&WSLST&"'!A:A"),A1)0,0))&"'!A :C"),2,0),"")