sheet 1
Models Price Received date
xbox 88.45 1/1/2015
xbox 99.00 1/6/2015
ps3 92.25 1/2/2015
nin 90.25 1/3/2015
nin 94.00 1/5/2015
sheet 2
Models FOB CFR
xbox 99.00 1.6
ps3 92.25 1.6
nin 94.00 1.6
sheet 1 will be a master list for new/updated prices received and will keep adding. so price and date is the determining factor.
sheet 2 will be where i do the calculation, adding in the cost of CFR into price.
i want to the formula to automate this process rather than i having to manually enter the last price.
ultimately i want to check for the latest updated price from the list and get the last price and this is via a comparison using models.
eg. i want to get the price for xbox. the return should be 99.00 and not 88.45. so 99.00 + 1.6.
im thinking vlookup,max,if.. but i cant get it to work.
please help.
Bookmarks