Hi all,

So in the data in tab "COGs", I need to look up the Buy price of the last entry into column D using the SKU.

However sometimes the SKU doesn't come back with an entry so we lookup the ASIN.

sidenote:Not sure if it is best to combine this into a single formula or to pull the asin data into another column for clearer checking.

Here is a link to the sheet.

https://docs.google.com/spreadsheets...it?usp=sharing

Hope this makes sense, thanks in advance.