Automatically Add Data to List from other List

L

LEGION

New Member
Joined
Apr 8, 2010
Messages
7
Hello everybody,

I need some input as to how to solve this problem.

I have worksheet A where I need to add a formula into column A2 to A30 which adds items from another worksheet B, B2:B25. However, this must be completely automatic.

The reference in B2:B25 is a unique identifier, for example IDENT1.
Now I need a formula that adds to A2 the first occurence of IDENT1 in column A2:A30 of worksheet B. Then, the formula should add into A3 of worksheet A the value of one row below IDENT1 first occurrence. And so on.

Is this possible with a formula in excel?
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

N
  • Question Question
Excel VBA: Form to be filled in with data from another worksheet
2
Replies
15
Views
560
MikeVol
MikeVol
N
  • Question Question
VBA to add title from formula to a save as name
Replies
0
Views
138
NKUNZI
N
G
  • Question Question
'Storing' and summing data before it is overwritten.
Replies
1
Views
202
gwoolley0302
G
N
  • Question Question
Excel VBA copy data to a worksheet in list form
Replies
0
Views
123
NewbieExcel123
N
R
  • Solved
Dynamic Dropdown list of sheet names
Replies
3
Views
511
alansidman
A

Forum statistics

Threads
1,224,588
Messages
6,179,743
Members
452,940
Latest member
rootytrip

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top