Microsoft Office Forums - View Single Post - Trying to input data from columns in cell

Thread: Trying to input data from columns in cell

View Single Post

Old

07-31-2013, 02:57 AM

gregjordan38 gregjordan38 is offline

gregjordan38 is offline

gregjordan38 uses Windows 7 32bit

Windows 7 32bit gregjordan38 uses Office 2007

gregjordan38 uses Office 2007

Office 2007

Novice

The original poster

Join Date: Jul 2013

Posts: 3

gregjordan38 is on a distinguished road

Default

Hi again Pecoflyer,

Finally got it, thanks for the suggestions as even searching under what you suggested helped. Think I had been at it so long my brain was melted.

=INDEX(Sheet1!$A2:A651,COLUMNS(Sheet2!$B1:B1),ROWS (Sheet2!$B$1:B1))

used that code and it works perfectly.

Reply With Quote