In one workbook, I have 4 sheets of data and one reference table. The data
tables have:

A B C
123 47 Text
123 47 Text
456 55 Text
455 66 Text
888 07 Text

The reference table has in a list values that match the values from column A
in the data sheets.
A
123
456
455
888

In the reference table (Sheet), in column B I am using:
=LOOKUP(A1,Sheet2!A1:B2,2,FALSE) to find values in Sheet2 and return cell B.


Also in the refrence table, in column C I have:
=INDEX('46501'!$I$2:$K$5,SMALL(IF('46501'!$I$2:$I$ 5=$A$1,ROW('46501'!$I$2:$I$5)),ROW(1:1)),3)

Dragging this formula down, I can get the values in Cell B from sheet 2 that
match.. How do I get them going across instaed of down and is there a way
to do the search on the other 3 sheets at once? Cannot combine them cause
will not fit in one worksheet. Please help.
Thanks.