Updating Pricing Question

Hi, I am tryign to combine a VLOOKUP function and an IF statement. Basically I want to quality check pricing for a product using an ID number, so do a VLOOKUP for the ID number, and if it exists in the new array, pull the price in the second column, but if the ID I’m looking for doesn’t exist in the array, keep the current price. Any help is appreciated

By: Laura

One thought on “Updating Pricing Question

  1. WayTooTricky



    Where A1 is the Product price, B1 is the original price and the 2 price arrays are in A3:B8 and C3:D8

Leave a Reply

Your email address will not be published. Required fields are marked *