Search column and return values

[inzain]

ok I have multiple columns where Col-A can have any number between 1 and 5. Col-B has a 3 digit number in it.

i want to search all of column A and determine if there is a 1 in it, if so i want it to print the value of col b into a specified area.


here is an example of my form.

COLA | COLB |
--------------
1 | 324 |
--------------
2 | 325 |
--------------
1 | 327 |
---------------

this is basics, i will be using this to search col-a, determine what number is in the column, then print the number found in col b, on another page in a specific place,

on the other page i have squares labeled 1-50
in a grid pattern, 10 squares per row.

im trying to get all the entries in col-a, that are a 1, to put whatever value is in col-b in the first box of the grid, whatever is found in col-a with a 2, the value found n col-b of that row, into the grid box labeled 2 etc...


so from the above example the first box labeled 1 will have both the numbers: 324 and 327 in it. i am sure i will have to paste the function into each row, but i will also need the function to determine if the number is already in the box.

it needs to be a function of sorts, so that i can later change the number in col-a to a different number if needed and it will then display that column's colb value in the box i set col-a's number to.


i hope that i have articulated this explanation into an understandable means

any help at all to figure this out would be greatly appreciated. thank you in advance

[NBVC]

Say your form is in Sheet1 and begins at A1 with corresponding codes in beginning at B1.

In C1 add a formula like:

Please Login or Register  to view this content.

which will count and concatenate column A to make a unique code for referencing.

Then in Sheet 2, say you have the numbers 1 to 50 listed in column A starting at A1, the in B1 use formula:

Please Login or Register  to view this content.

copied down to row 50 and then across 10 columns.

See attached.

[inzain]

thanks very much for the quick response, it worked like a charm with simple adjustments, for what i needed.