Table look up formula
Table look up formula
(OP)
I am creating a new template and cannot get the lookups & match functions to work together in a formula the way I need them to. I would like to create a formula that will take the values entered in Cells B4-B6 on sheet 1, search the table on sheet 2 and place the corresponding values on sheet one in cells B7 & B8.The table I entered on sheet 2 gives values for both "h" & "a1" depending on the belt width, surcharge angle, and type of idler. Looking for help on how to go about having excel do the table searching. I have attached my Excel file.





RE: Table look up formula
This will make your lookup functions work much better.
But I also have to ask if you can't calculate h and a1 directly without using a table? You could still include the table as a reference.
RE: Table look up formula
RE: Table look up formula
=====================================
(2B)+(2B)' ?
RE: Table look up formula
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Table look up formula
RE: Table look up formula
RE: Table look up formula
RE: Table look up formula
That formula you provided is awesome & works perfect! I do not follow it, but will be spending some time with that formula and the excel help menu. It looks like renaming the reference cells is big though