Forum Discussion
help in excel
here's image 1 with code matching different SKU. let's say this is file A
I need copy and past file A's code into file B. However file B is looking different
when I paste file A's code into File B. here's what it looks like
I will have to manually drag the code to matching the correct SKU, and keep copy and paste them.
my concern is : is there anyway we can make it quicker and easier ?
I hope I explained clearly, anyone know any way to help me with this issue, Please HELP !!
Does my response at https://answers.microsoft.com/en-us/msoffice/forum/all/is-there-any-way-to-make-this-autofill-please-help/6acf9d92-988f-4547-b733-89b307b515be solve your problem?
7 Replies
sheri_021 this may be helpful for you. try vlookup.
Johnathan1111 thank you…
- No problems. I uploaded the screenshot in last reply, but I cannot see it...I don't know where it goes wrong.
Does my response at https://answers.microsoft.com/en-us/msoffice/forum/all/is-there-any-way-to-make-this-autofill-please-help/6acf9d92-988f-4547-b733-89b307b515be solve your problem?
- actually I change your equation like below for 2nd row
More generally (allows column B data to be text or numeric):
=IF(OR(A2="",A2=A1),"", INDEX(B$2:B2, SUMPRODUCT(--(C$1:C1<>""))))
Change to :=IF(OR(A2="",A2=A1),"", INDEX(B$3:B2, SUMPRODUCT(--(C$1:C1<>""))))
then rest of them fill correctly.
I don't understand why, I was just give it try and play around. I don't know how to fix to make it correctly auto fill from row 1 - OMG ~~~~ it does, the 2nd equation does the work.
but there's little issue.. I replied and post it over there...
YOU ARE AMAZING !!!! thank you so muchsheri_021 wrote: ``there's little issue.. I replied and post it over there``
And that's the problem with crossposting: trying to keep both threads up-to-date.
I am continuing the discussion only at answers.microsoft.com.
