Populating a column in order with an adjacent column

Hi,

I know my way around Excel a bit but am stumped with this and dont really know where to start. On the attached picture I have shown data in column A, B, and C. The data in column A is fixed and I want to sort the data in column B and C so it matches column A eg:

After pasteing the data in Column B and C, 1001 in B goes from cell B4 along with the value in C4 into position B2 and C2 respectively

I want this to carry on down the sheet for around 200 items. If there is a gap (say 1020, 1021 then 1024) then the formula needs to skip those rows to keep the number in column A and B the same.

Is this actually possible??

Thanks for any help.Excel.jpg

Originally Posted by Special-K

If you insert two columns between A and B then

in B2
=IFERROR(VLOOKUP(A2,D$2:E$8,1,0),"")

in C2
=IFERROR(VLOOKUP(A2,D$2:E$8,2,0),"")

and copy the formulas down columns B and C
will return the values without the need for sorting and also solving your gap problem.

This did not seem to work unless I am missing the obvious. Please attached image. Thanks for any advice. If I can get this to work it will revolutionise my barcode system.

try this, not pretty but functional
haven't tested for duplicates

Please Login or Register  to view this content.

Originally Posted by paperbo

This did not seem to work unless I am missing the obvious. Please attached image. Thanks for any advice. If I can get this to work it will revolutionise my barcode system.

Solved now

Just removed the =iferror function and changed it.

I've read up on the vlookup function and get it now.
A blank query now shows as #N/A and the list continues correctly.

Originally Posted by paperbo

Solved now

Just removed the =iferror function and changed it.

I've read up on the vlookup function and get it now.
A blank query now shows as #N/A and the list continues correctly.

image.jpg (4.81 MB)