View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bim-bom bim-bom is offline
external usenet poster
 
Posts: 2
Default Formula for finding an element

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