| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If AND query
Hi guys, I am trying to establish if I can use the AND function with IF in
the following formula. The formula below retuns a row number based on the criteria B6 in current sheet ( Sheet 2 ) if it matches the data in cell C4 of Sheet 1, I would like the formula to return the same data ( row number ) based in C4 of Sheet 1 and E4 of Sheet 1 ,,,, I've tried adding an AND statment but couldn't get it to work. =IF(B6="","",IF(B6=Sheet1!$C$4,ROW(),"")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
