Thread: multiple columns and row table and finding the answer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelrookie excelrookie is offline
external usenet poster
  
Posts: 20
Default multiple columns and row table and finding the answer
Looking for the correct Function

I have a table that looks sort of like this

A B C D E F G H I J

A 14 14 11 10 9 8 7 6 5 4
B 2 14 14 11 10 9 8 7 6 5
C 3 2 14 14 11 10 9 8 7 6
D
E Etc Etc Etc

I want to right a formula that will return the correct value in the table.
So if I enter A A then 14 if it is B A then 14 but if A B then 2. Any
idea's where I can start?
Reply With QuoteReply With Quote