| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(and statements using data in an array
I would love some help with the following statement. {=if(and(b2='DBP -
09'!D:D,C2='DBP - 09'!E:E),'DBP - 09'!K:K,0)}. I've previously used excel 97 and am now using excel2000, so not sure if something has changed from that version to this. The formula returns a #Num error. I've tried every combination and can't get it to work. The sheet called 'DBP-09' contains names and salary details. I'm looking up the person's first and last name and returning the salary value for that person (obviously,where there's a match found). Help greatly appreciated!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statements in Data Validation | Excel Worksheet Functions | |||
| Data Validation - IF statements | New Users to Excel | |||
| IF statements and moving data to different columns | Excel Worksheet Functions | |||
| Data Validation w/ If, Match & Index Statements | Excel Worksheet Functions | |||
| Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
Threaded Mode
