The solution I provided will do just that. However, it uses several
formulas to achieve what you want. It's a formula system I learned from
Aladin. It's very efficient, especially if you're dealing with a large
amount of data. But if you prefer, you can use the following single
formula instead...

Sheet1!B2, copied down:

=IF(ROWS(Sheet1!B$2:B2)<=COUNTIF(Sheet2!$A$1:$A$5, Sheet1!$A$4),INDEX(Shee
t2!B$1:B$5,SMALL(IF(Sheet2!$A$1:$A$5=Sheet1!$A$4,R OW(Sheet2!$A$1:$A$5)-RO
W(Sheet2!$A$1)+1),ROWS(Sheet1!B$2:B2))),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
Rhonda wrote:

Let me try to explain it better because now I am lost.

Worksheet 1: Worksheet entry
Row A4


Worksheet 2: Database

A1=A1234 B1=Cold
A2=A1234 B2=Hot
A3=A1234 B3=Mild
A4=B789 B4= Red
A5=B789 B5= White

On Worksheet 1:
When I type A1234 in row A4
I want the following in B2, B3, B4,
B2=Cold (From Worksheet 2, B1)
B3=Hot (From Worksheet 2, B2)
B4=Mild (From Worksheet 2, B3)

On Worksheet 1:
When I type B789 in row A4
I want to see the following in B2, B3, B4,
B2=Red (From Worksheet 2, B4)
B3=White (From Worksheet 2, B5)

Do you know what I mean?