Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello, Is it possible for me to search two cell with different text in one
sheet and if the to cells match with another two cells in other sheet it retrieves a value corresponding to another cell. Kind regards Relax |
#2
![]() |
|||
|
|||
![]()
something like
=IF(AND(A1=Sheet2!A1,A2=Sheet2!A2),B3,"") -- HTH Bob Phillips "Relax" wrote in message ... Hello, Is it possible for me to search two cell with different text in one sheet and if the to cells match with another two cells in other sheet it retrieves a value corresponding to another cell. Kind regards Relax |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a formula to retun a value of 0 (zero) when a VLO. | Excel Worksheet Functions |