Forum Discussion
Juggling items from one column to it's corresponding row in a new column
I've got an inventory list in column A of all my meds (about 300). I've got a medication usage list in a different column (say, C) that only has the list of meds that I've dispensed in the last month...
Thanks Bos. This gives some options to play with.
Before I try some of those formulas, tomorrow, I've got one more question: The meds in column C all have numbers associated with then in col. D (not shown). After I move col. C, over, how do I reattach those numbers to the items in the new Col. B?
Mm... if you have the article numbers, use them instead of the names and you will get better results since it may happen that two different numbers share the same name.
Adjust the formulas to use the numbers;
D2 =IFERROR(VLOOKUP(A2;G:I;3;0);0)
- My version of Excel doesn't like this formula =IFERROR(VLOOKUP(A2;G:I;3;0);0)
I've got Office Professional Plus 2019
Could that be the problem?- Also, what does the 3 do, in the formula? I know 1 and 2 have to do with matching exactly or closely.
- What I posted was just a small part of the spreadsheet, Darn, this looks better than my original.
Thank you!
I'm going to try that.- 🙂 You're welcome.
Also, by using the article numbers/ID's even in the shorter list you will cut the risk of misspelling the names and thus miss or point wrong in the inventory list.
If you continue using names in the subscription/small list (that may be what you are used to since it is more handy), it will be a good idea to append also Riny van Eekelens formulas to see that you get an inventory match on the name.
