On Sheet5, starting in B1 I have
1 cat apple
2 dog pear
3 horse plum
4 donkey apricot

On Sheet4 in A1 I entered 3
In B1 I have =VLOOKUP($A$1,Sheet5!$B$1:$D$4,COLUMN()-1,0)
This is copied to D1
Row 1 now shows
3 3 horse plum

Any use?
Please: your workbook contains WORKSHEETS, while TABS are the things you
click to open a worksheet
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"KC" wrote in message
...
I have a tab called Status with one column with unique numbers in column B.
On my 2nd tab called Triple, the column headings are all the same as on
the
Status tab. What I'd like to do, is on the Triple tab, if I type in one
of
the unique numbers from the Status tab, I'd like all the information on
that
row, populated on the Triple Tab.

So, for instance, if Status tab B12 says 5512 and on the Triple tab in
cell
B2 I type 5512, I want all the information that is already populated on
the
Status tab row 12, to be populated in the Triple tab row 2.

I thought maybe a lookup formula might work, but its not. So maybe I'm
going about this all wrong. Can anyone help?