I have hit a brick wall while trying to write this formula. Attached I have a sheet that would calulate the total weight of a shipment of Probes, our product, I have two tables. The first table is where the employee would enter the Length of the Probe, and the Length of the cable attached. The second table is made of tested and weighed probes all with 10ft cables. I would like to write a formula that compute the weight if there is a longer length of cable attached. I have a list on the sheet of just the cables by weight and length, along with the weight difference. I have a formula in the Weight column using VLOOKUP to table two, I got confused when I tried to write =IF("cable length" =10ft,(VLOOKUP(bla,bla,bla,True)??? thats where I draw a blank. Please and Thank You in Advance.
Bookmarks