Hi Forum! It's been a long time. I'm back again now and hoping for some more of your generous, valuable help.
I need a cheap price quote tool to use in google sheets. I found this one here, that came out about 10 years ago:
{link removed until I've posted a few times... but it can be found by googling "Google Sheets Quote Builder bettercloud"}
It seems to be perfect for my purposes, but as I've made modifications, it seems to be getting a bit wonky.
the key formula seems to be this one:
=iferror(vlookup("x", indirect(concatenate("Product_Listing", "!", "A",Match(B20,Product_Listing!$B$3:$B$205, 0) + 3,":B106")), 2, false),"")
Which enables a line item marked with an "x" in column A on sheet "Product_Listing" to appear as a line item on the quote page.
I'm finding some problems, though:
(1) some line items don't show up when marked with an "x"
(2) line items that are similar (for example similar names in column B, but some different attributes in columns C and D, cause problems:
(a) The first one to appear on the list repeats to fill all the line items in the quote field.
(b) The 2nd one on the list never appears, if it is checked, the situation from (1) repeats.
I imagine this has to do with the test of the lookup, it just grabs the fist one it comes across.
(3) repeating lines begin around line 106. I see there is a ":B106" in the code, but I am unable to change it for some reason. Not sure if that has anything to do with it.
Any help would be greatly appreciated! I would need this to work with a product list of approximately 300 lines.
thanks very much in advance!
I see I'm not allowed to post files or links until I've posted a few times, I guess it's been longer than I thought, that I've been away!
regards!
Bookmarks