Hi there
This topic has been covered before but as I am a novice I really don't understand the explanation. Please can someone assist me with my query:
I have a main database with all my product info and pricing. I would like to create a price list based on specific criteria.
Firstly, I have no idea which formula to use to pull the Item no (SKU) into the relevant product category tab. For this exercise, I just sorted my data and copied the SKU number and then used Index/Match to find the info, which works fine however, I don't want to copy and paste the SKU number each time, I would like the relevant tab to update with the new product etc. I am sure it is simple but as mentioned, I am a novice.
Secondly, I would like the price list to only pull data that meets the criteria i.e. I only want items from Countries to appear in the section for that particular country. Or if I want to select based on a Category. I have tried IF / Index & Match and just cannot figure this out. It pulls up the correct first cell and then repeats it or pulls in data that doesn't match??
=INDEX('Red Wine'!$A$3:$A$93;MATCH($B$6;'Red Wine'!J3:J93;0)) -
=IF(Champagne!I3:I94='CHAMP Price List'!$B$6;INDEX(Champagne!$A$3:$A$94;MATCH($B$6;Champagne!I3:I94;0);0);0)
I would appreciate any assistance.
Thank you
Lesley
Bookmarks