Trying to automate a column based on three columns input(Lookup).have made a table with the info for Lookup to use for the end result and am testing before i complete the end result table. Cannot get function to work.
Numbers 3.6.2
Mac pro early 2009
EL Captain 10.11.6
—–
jesse scott
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Use the Lookup Function With Multiple Inputs?
Comments: One Response to “How Do I Use the Lookup Function With Multiple Inputs?”
Comments Closed.
Can you explain in more detail what you are trying to do? Maybe include an example? The LOOKUP function is usually used to get a value in one column based on the value of another column. For instance, product names in one column, and then prices in another column. Then you can look up the price based on the product name.
If you want to do this with multiple criteria, one way is to create a new column in your main table. Use a formula to combine the three other cells. So if they are A1, B1 and B3, you would use =A1&B1&B3 in this new column. Then use a LOOKUP based on that new column. So if the LOOKUP is in another table then =LOOKUP(B1&C1&D1,Table 1::E,Table 1::D) where you put the three parts to lookup in B1, C1 and D1 and then refer to this combo column in table 1 (E) and grab the value from table 1's column D.
It is fortunate that we can use & inside of the first parameter of the lookup function. Also, note that you can hide this special combo column in table 1 if you'd rather not it be visible.