| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW DO I FIND DATA IN A TABLE BY LOOKING UP BOTH THE COLUMN AND R.
If I have a table for example
| A | B | C | D -------------------------------- 1 | | A | B | C 2 | X | 1 | 2 | 3 3 | Y | 4 | 5 | 6 4 | Z | 7 | 8 | 9 5 | 6 | A 7 | Y Is there a function that does the following? =FUNCTION(A6,A7,A1:D4) and return 4 Thnaks in Advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Threaded Mode
