J
Joshua
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I have 2 tables and the values in the 1st column of each table are the same, but in differing orders. What I want to do is enter a formula column into the 1st table that uses the first column of the two tables like a key to pick a cell from a different column in the second table.
The functions I've found which appear to do this are LOOKUP, VLOOKUP, and MATCH. My problem lies in that all 3 require the column of table 1 to be sorted in descending order. I can't do that, the order is fixed and rational, but not in descending order.
Once I get a working formula I plan to copy and past the formula into 20+ tables, and having to manually sort any of the columns will defeat the purpose of using a function to do the heavy lifting for me. It would take the same amount of time to just copy and past the values myself.
Is their a way to get around this need for the columns to be sorted?
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I have 2 tables and the values in the 1st column of each table are the same, but in differing orders. What I want to do is enter a formula column into the 1st table that uses the first column of the two tables like a key to pick a cell from a different column in the second table.
The functions I've found which appear to do this are LOOKUP, VLOOKUP, and MATCH. My problem lies in that all 3 require the column of table 1 to be sorted in descending order. I can't do that, the order is fixed and rational, but not in descending order.
Once I get a working formula I plan to copy and past the formula into 20+ tables, and having to manually sort any of the columns will defeat the purpose of using a function to do the heavy lifting for me. It would take the same amount of time to just copy and past the values myself.
Is their a way to get around this need for the columns to be sorted?