Forum Discussion
unequal tables
Hi there, my columns are unequal: see attached (yellow columns). How can I equalize them to column 1, to have proper data in rows? Thank you for any tips.
WassimN I have commodity good code in column B, D, F, H, K for annual value of import (column C, F, H, J, L). All these goods codes should correspond to the code in the first column (all codes list). They do not. See pic.
Hello Eliza55,
Still Not clear. the data in Column B is not the same as Column D but that is not the important issue. I would suggest stating your question in a couple of examples such as:
I want Cell C2 to be xxx because Cell A1 has 101, and then I want Cell C3 to be yyy because Cell A1 has 102. And many of these pointers so that we can figure what is best. You know your project inside-out, but we don't and we need to be able to make that mental image as to what the final outcome will look like to get you the best results. Right now, with my very limited understanding of what is needed, I am thinking you should look into the XLOOKUP function, but then again, very limited understanding.
Still Not clear. the data in Column B is not the same as Column D but that is not the important issue. I would suggest stating your question in a couple of examples such as:
I want Cell C2 to be xxx because Cell A1 has 101, and then I want Cell C3 to be yyy because Cell A1 has 102. And many of these pointers so that we can figure what is best. You know your project inside-out, but we don't and we need to be able to make that mental image as to what the final outcome will look like to get you the best results. Right now, with my very limited understanding of what is needed, I am thinking you should look into the XLOOKUP function, but then again, very limited understanding.
- OK, I want cells in column B equal to column A, but B should change together with column C values. So, cell B22 need to go down to the row 32, it should go together with a value in the cell C22.