Search results

And you sir, are a gentleman and a scholar. You're right, the table is way bigger than that - it's actually a product costing matrix - but adding the numbers at the bottom and using hlookup/vlookup works great. I knew NSC would know the answer!!

Yeah I was trying to avoid an IF/AND for that exact reason, it would be nested a hundred times and I'd go cross eyed trying to write that formula! That's why I'm guessing a variation of some sorts on a lookup is the answer - if the column header is X and the row header is Y, return Z, with Z...

I know NSC loves an excel puzzle...This may be quite easy for the resident geniuses but it's got me stumped! I have a problem where I have two cells using validation so all that can be selected is the column headers and row headers of a table elsewhere in the sheet. I want in a third cell to...