Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a spreadsheet: 1 2 100 5 6 200 5 11 300 I want to find a row which where first column has a specific value and the second column has a specific value, and print a value in the third column. So, I want something like: = FIND_VALUE (A1:A3 ; 5 ; B1:B3 ; 6 ; C1) // finds 5 in the first column and 6 in the second And it should show the value 200 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use a single nonrepeating XML element in a cell formula | Excel Discussion (Misc queries) | |||
look for missing element | Excel Worksheet Functions | |||
nth element extract | Excel Worksheet Functions | |||
How to define the 1st, 2nd and 3rd element | Excel Worksheet Functions | |||
How do I prevent a formula element from incrementing when copying | Excel Worksheet Functions |