Formula to copy data based on the text in the cell

Closed
Aska Posts 164 Registration date Friday December 8, 2006 Status Member Last seen May 3, 2020 - Apr 18, 2016 at 10:07 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Apr 19, 2016 at 11:23 AM
Hello,

I need to find out how to do this (and would be grateful if anyone could help me with this):

I have a tab (1) in Excel with ten thousands of rows for ten thousands of different projects containing, among others, the ID number, the title, and the description of different projects (in three different columns).

In another tab (2), I have a selection of these projects (reduced to a +/- 500 projects) for which I only have the ID number in a column.

Now, as you can guess, what I would need, is a formula (or anything else) to automatically copy of the title and description of the project from tab (1) to the selected projects in tab (2).

Something like: if the ID number is 123 in tab (2), then find this ID number 123 in tab (1) and copy the data that is the other cells of the row of tab (1), to the cells that are in tab (2).

It seems easy said like that but I just can't find a way to do it...

Thanks in advance for your help!

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 18, 2016 at 10:33 AM
Aska, Good morning.

As we don´t know the precise layout about your file we can only advise you.

This kind of necessity you mentioned can be solved with a use of VLOOKUP function.

To a precise solution, please save your file at a free site, www.speedyshare.com and put link to download here.
Aska Posts 164 Registration date Friday December 8, 2006 Status Member Last seen May 3, 2020
Apr 19, 2016 at 04:21 AM
Hi Mazzaropi,

Thank you for your quick reaction!

I tried with VLOOKUP but only came out with FALSE-TRUE results, which is not what I am looking for... (but I am not sure I used it correctly...)

I cannot put the real file here, as there is some confidential information in it, but I created a similar file with similar data here:
http://speedy.sh/tQqU3/Example-projects.xls

Does that help?
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 19, 2016 at 11:23 AM
Aska, good morning.

As I said before, VLOOKUP is a perfect function to this case.

Take a look at your example with an implemented function:
http://speedy.sh/YM45j/19-04-2016-enKioskea-Example-projects.xls

Please, tell us if it worked for you.
I hope it helps.