One way ..

Put in A3: =IF(A1="","",A1)
(Revise the formula a little ..)

Select C3:J3

Put in the formula bar:
=IF(A3="","",VLOOKUP(A3,A4:$J$10,{3,4,5,6,7,8,9,10 },0))

Array-enter the formula, i.e press CTRL+SHIFT+ENTER

C3:J3 will return the desired results

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"fluci" wrote in
message ...

A1 is any word
A2 is blank
A3 = A1
A4:A10 = random words
C3:J3 = Reference words
$C4-10:$J4-10=Random words
What I need is when I type in a word from A4:A10 into the Cell A1, the
cell A3 becomes that cell and it makes cells C3:J3 the corresponding
values of the same row as the A4:A10 value

For example
IF I type Reference into A1, I need it to look like this

Reference Test No HA DING (etc)

Reference Test No HA DING (etc)
Blank
Moop
Red
Interesting
Juggling
Nine
Ten



Can anyone help me?


--
fluci
------------------------------------------------------------------------
fluci's Profile:
http://www.excelforum.com/member.php...o&userid=25896
View this thread: http://www.excelforum.com/showthread...hreadid=393190