Forum Discussion
Need to calculate based on values from two separate drop down Lists
list of 16 cars, 16 brands and 16 different prices. I have a main sheet with my data, a second sheet with the table containing the drop down lists. My formula spills. I cannot for the life of me figu...
Without seeing your actual workbook, it's hard to be sure. I do notice that the first argument in your VLOOKUP formula is itself an array, and my own suspicion would be that that might be the problem. Usually one uses a single cell as the first argument.
If you were to post your actual sheet, we (I and others) could take a look at it. Just make sure it's not got any confidential info on it
That could be
=IFNA(INDEX('Main Sheet'!$A$4:$Q$20, MATCH([@[From ]], 'Main Sheet'!$A$4:$A$20,0), MATCH([@To],'Main Sheet'!$A$4:$Q$4,0)),0)- You guys are the absolute best! I didnt even try the match thanks so much for you help. Now I'll never forget it
