Question About Excel Columns

Hi and welcome to the forum,

I find it hard to visualise what you are saying. Would you upload the workbook or at least a cut down representative copy. Show a before and after situation manually adding the results you expect to see.

Incidentally would you change your location to something meaningful. This often helps when we need to consider things like time zones and regional settings for dates and list separators.

Hi, welcome to the forum

i *think* I understand what you want...

	A	B	C	D	E	F	G
1	Old A	Old B	New A			New Import
2	1	aa	1			aa	1
3		bb	0			bb
4	2	cc	2			cc
5		dd	6			dd	6
6	3	ee	3			ee
7		ff	7			ff	7
8	4	gg	4			gg	8
9		hh	9			hh	9
10	5	ii	5			ii
11		jj	10			jj	10

C2=IF(A2="",VLOOKUP(B2,$F$2:$G$11,2,0),A2)
copied down

Hi Richard,

Thanks for the fast reply. I have changed my location to something meaningful, hopefully it is sufficient now.

I have uploaded three files that I just created. First file (1.xlsx) represents the original Excel sheet. As you can see, all rows in column B are filled but only some are filled in column A.

File 3 represents the outcome of running values of column B through the software I was talking about earlier. As you can see, it contains many more values in column A than file 1 does because the software is able to retrieve these values for values of column B. File 3 does not contain values in rows 3, 5, 10, however, because I would not want to copy values in these rows even in case the software did come up with them because as already mentioned above, I would want to keep the original values (that were contained in file 1, in rows 3, 5, 10).

File 2 is the combination of file 1 and 3. It is the desired outcome. Column A is much more filled with data than it originally was, but as you can see, rows 12 and 13 are still empty. That is because the software is not perfect and is not able to retrieve a value for every single column B value that I run it for.

I hope it makes more sense now. My question is, is there a way to copy the column A values contained in file 3 into the final file 2 without having to do it manually, one by one?

I see you have 3 files, but was post 3 of no use to you?