Ok, here is my problem and excuse if its in the wrong forum. I have one list I get from a vendor with all current products. I also get another list with all discontinued products. These are hundreds in both. So, I want to know is there a way I can take sheet A(discontinued products)and update sheet B(which will have both current and discontinued)to be updated with sheet A to only have current products and erase all of its discontinued. I hope I was clear.
I think this can help you.
I need your support to add reputations if my solution works.
The manual version would be to add a column to your B sheet with a VLOOKUP function/formula in it.
your formula would be something along the lines of:
Where:
Please Login or Register to view this content.
A2 is the product that you are checking to see if it is on the Active list.
Sheet1!A:A is the column with the Active products listed (their names / IDs)
1 = the column number that has the data you are looking for - in this case you only have one column in your table, but the VLOOKUP can return any column's data as long as it is in your table
False = Match the item / ID
Copy the formula all the way down to the end of your table.
Sort on the VLOOKUP column - if you sort ascending scroll to the bottom of the list and delete all rows that have a result of #N/A in the column. If you sort descending the #N/As will be on the top.
Last edited by mdbct; 09-21-2008 at 09:17 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks