| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Duplicates in Multiple Columns | Excel Discussion (Misc queries) | |||
| Using VLOOKUP to locate an answer in one of multiple columns | Excel Worksheet Functions | |||
| Finding duplicates in Multiple Columns | Excel Discussion (Misc queries) | |||
| Finding & Replacing a list of Data in Multiple Columns | Excel Worksheet Functions | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
Threaded Mode
