Good Evening Dear Forum Members,
I have a workbook with a sheet containing a list of books , I want to have the current prices of the Items listed in a column beside the product details. That needs to be extracted from Amazon, Barnes and more.
Example:
Item ISBN Price
Book 1 12345678
Book 2 87654321
In the price column, I would like the sheet to display the current price, by using the ISBN.
Thanks in advance
Last edited by rameshantony2000; 05-30-2022 at 10:35 AM.
You can use a VLOOKUP or similar function to match the price from your price list to the ISBN number:
=VLOOKUP(ISBN,price_list,2,0)
where the price list is listed in two columns (ISBN on the left and price on the right.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear Sir,
Thank you for your reply and sorry for not mentioned the exact query. Actually I need to pull the item price from the Amazon based on the ISBN in the excel sheet.
OK - so do you have a link to Amazon's ISBN price list? With that, we may be able to help you set up a PowerQuery to extract the data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks