Populate Cells based on Separate Sheet
I'll do my best to describe this... (Attached Spreadsheet)
Sheet 1 contains a 5 reference number down Column A...
A
00001
00002
00003
Sheet 2 contains text in B1, C1, D1 etc.....
B1 = Test 1
C1 = Test 2
D1 = Test 3
If there a formula that once a reference number is typed into the next cell down in Column A (e.g 00004), the cells next to it are populated with the cells from Sheet 2
Exact same issue I am facing right now, interested to see if there is an answer.
May be try in A1Formula:
=INDEX(SUBSTITUTE(Sheet2!$B$1:$CF$1,"Test ",""),ROW(1:1))
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Can't get that to work I'm afraid.Originally Posted by shukla.ankur281190
May be try in A1Formula:=INDEX(SUBSTITUTE(Sheet2!$B$1:$CF$1,"Test ",""),ROW(1:1))
Do you need to populate Test 1, Test2 and so on....? If is this you want the try in sheet 2
B1Formula:="Test "&INDEX(Sheet1!$A:$A,COLUMNS($B1:B1))
drag towards the cell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks