Microsoft Office Forums - View Single Post - [Solved] from two cell to one?

Thread: [Solved] from two cell to one?

View Single Post

Old

01-10-2012, 02:21 AM

gsrikanth

gsrikanth is offline

gsrikanth uses Windows XP

Windows XP gsrikanth uses Office XP

gsrikanth uses Office XP

Office XP

Competent Performer

The original poster

Join Date: Dec 2011

Posts: 133

gsrikanth is on a distinguished road

Default

from two cell to one?

if cell 1 contains
aero refer to ='Page 1'!$A$1

and cell 2 conains
plane refer to ='Page 1'!$B$1

I want to get ='Page 1'!$B$1 in this cell are "aeroplane"

avoiding taking right side column and concatenate

Reply With Quote