#1   Report Post  
Relax
 
Posts: n/a
Default 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
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a formula to retun a value of 0 (zero) when a VLO. Adam at GTOFL Excel Worksheet Functions 4 February 20th 05 06:15 AM


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"