Hi, I am trying to do my taxes this year. Basically, where the ASIN number is e.g.

B08926LGV2

B08926LGV2

B087R11FDK

B094NY4XZ7

B087R11FDK

B07C7WLDD3

B00PZZFG0O

I want it to match the asin column with a cost (in dollars $) into the cost column. So if B00PZZFG0O costs $30, how would I make a function to check the asin I specify, and if it is true, put the cost in the other column. They are in the same row.

There are like 300 rows and I do not want to do it manually.

Please let me know if this is confusing and I will try to summarize it better.

A35CGHCPOIWYHP MEN B08926LGV2 VI-WBG1-SYDE A35CGHCPOIWYHP MEN B08926LGV2 VI-WBG1-SYDE A35CGHCPOIWYHP MFN BO87R11FDK 1L-AKDB-ZRGC A35CGHCPOIWYHP MEN B094NY4XZ7 SB-QODZ-U10 A35CGHCPOIWYHP MFN BO87R11FDK 1L-AKDB-ZRGC A35CGHCPOIWYHP MFN B07C7WLDD3 BT-C108-MC06 A35CGHCPOIWYHP MEN BOOPZZFGOO XA-EFBH-NCOG A35CGHCPOIWYHP MEN BOOPZZFGOO XA-EFBH-NCOG A35CGHCPOIWYHP MEN BOOPZZFGOO XA-EFBH-NCOG A35CGHCPOIWYHP MEN B076341X09 19-L6NC-J22W A35CGHCPOIWYHP MEN B076341X09 19-L6NC-J22W SHIPMENT Marketplace Facilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD Sale Price Cost 291.49 FALSE 291.49 137 291.49 FALSE 291.49 137 79.95 FALSE 79.95 83.98 FALSE 83.98 79.95 FALSE 79.95 41 FALSE 41 79.99 FALSE 79.99 0 83.99 FALSE 83.99 83.99 FALSE 83.99 684.22 FALSE 684.22 129.77 FALSE 129.77 A35CGHCPOIWYHP MEN B08926LGV2 VI-WBG1-SYDE A35CGHCPOIWYHP MEN B08926LGV2 VI-WBG1-SYDE A35CGHCPOIWYHP MFN BO87R11FDK 1L-AKDB-ZRGC A35CGHCPOIWYHP MEN B094NY4XZ7 SB-QODZ-U10 A35CGHCPOIWYHP MFN BO87R11FDK 1L-AKDB-ZRGC A35CGHCPOIWYHP MFN B07C7WLDD3 BT-C108-MC06 A35CGHCPOIWYHP MEN BOOPZZFGOO XA-EFBH-NCOG A35CGHCPOIWYHP MEN BOOPZZFGOO XA-EFBH-NCOG A35CGHCPOIWYHP MEN BOOPZZFGOO XA-EFBH-NCOG A35CGHCPOIWYHP MEN B076341X09 19-L6NC-J22W A35CGHCPOIWYHP MEN B076341X09 19-L6NC-J22W SHIPMENT Marketplace Facilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD SHIPMENT MarketplaceFacilitator Amazon 1 USD Sale Price Cost 291.49 FALSE 291.49 137 291.49 FALSE 291.49 137 79.95 FALSE 79.95 83.98 FALSE 83.98 79.95 FALSE 79.95 41 FALSE 41 79.99 FALSE 79.99 0 83.99 FALSE 83.99 83.99 FALSE 83.99 684.22 FALSE 684.22 129.77 FALSE 129.77