| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF & AND combination not working
I'm trying to get the value of one cell from a Data worksheet into an
specific one. The formula is as follows: IF(AND('Data'!C5:C50003=A2,'Data'!A5:A50003=A4,'Da ta'!D5:D50003="Land"),'Data'!E5:E50003,0) Were A2 is a country name, A4 is a date and the value to bring back is a number. What can I do since there is only one value in the Data spreadsheet that would comply with all 3 conditions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate working days but change working week | Excel Discussion (Misc queries) | |||
| Combination Sum | Excel Worksheet Functions | |||
| Combination charts | Charts and Charting in Excel | |||
| combination | Excel Discussion (Misc queries) | |||
| Combination | Charts and Charting in Excel | |||
Threaded Mode
