Google Sheets. Lookup the last entry

[samvince]

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.

[Flyboy65]

Since you didn't show what your expected results would be, I took a stab in the dark. Put the following formula in cell D2 of the COGs tab:

=ArrayFormula(IF(A2:A="",,XLOOKUP(B2:B,'Buy Sheet'!$A$2:A,'Buy Sheet'!$C$2:C,XLOOKUP(C2,'Buy Sheet'!$B$2:B,'Buy Sheet'!$C$2:C,,-1,-1),-1,-1)))

Let us know if that's what you're after.

[samvince]

cheers thanks for this, I've added the example output now.

But your formula works. Cheers