Multiple IF statements in 1 formula

Thanks for your reply!

I have attached both copies of the workbook. 'Workbook' is how we have it setup from our suppliers feed, It already has numerous changes that we have made from the standard text file that we get.... 'Online ready workbook' is how it needs to be for the website upload.

column C has the data that we need changed from column B, since there is so many products and this needs to be done 3 times per week i would like a formula that could be inserted into column C that changes the data automatically if possible and only changing the appropriate names (from the post above).

These are the only names that we would be changing, but the spreadsheet needs to be mindful that rows will changed every 2nd day... ie some products will change / be added / removed etc.

All columns will remain the same

Thanks

Using stanleydgromjr's suggestion -

I have added a sheet with a lookup table if you add more rows to the table it will need to be changed in the column C formula range

Please Login or Register  to view this content.

Where $A$1:$B$14 is the range.

thanks for the reply!

can you please explain to me where it gets the data from to put into column C? does it need to have a database so that it knows what to change the data too?

Yes, you need to maintain the source database (worksheet "lookup table") with column A being the original data and column B being what you want it changing to.

thanks for your help!