ExcelBanter - LookupV

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LookupV (https://www.excelbanter.com/excel-worksheet-functions/42014-lookupv.html)

Relax

LookupV

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

Bob Phillips

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

All times are GMT +1. The time now is 01:12 AM.