I want to keep column A in the order its in. But I want column B and C to match the skus in Column A.
There are more skus in column A than B, Spaces are ok for the sku's that dont have a partner. I just want to make sure column A stays in the order that its in.
Sorry noob here.
thank you in advance for the help. Hopefully my attachment works
Krishelp.xlsx
Excel 2016 (Windows) 64 bit
=VLOOKUP(A1,$B$1:$C$818,1,FALSE)
Sheet: Sheet1
and paste down
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
THIS IS AMAZING, I messed up though, can you give me the formula so column B stays in the same order when I paste? thank you so much Alan!!!!
Kris
Cannot. All you can do is copy the data from the other columns and Paste Special into Column B. The formula relies on the data in Column B to find the results so it cannot be changed with a formula for what you are asking.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks