B

#### BobbyRT

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.