If(and statements using data in an array

L

Lou H

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!!
 
L

Lou H

Just tried it and it doesn't work although its now returning 0 rather than
#NUM - would it something to do with the lookup data being text ?
 
J

Joel

The formula is working, yo ujust aren't getting the results you expect. I
debug formulas using the Evalute formula tool. Select thhe cells with the
formula then use menu

Worksheet Menu - Tools - Formula Auditing - Evaluate Formula
 
L

Lou H

Would that be an add-in option?

Joel said:
The formula is working, yo ujust aren't getting the results you expect. I
debug formulas using the Evalute formula tool. Select thhe cells with the
formula then use menu

Worksheet Menu - Tools - Formula Auditing - Evaluate Formula
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Taking the Zeros out of an array when displaying 7
VLookup and Sum If formula 3
Array formula with and/or statements 8
Number of days in overlapping date ranges (using array formula?) 7
lookup help. lookup result based on data in 2 columns 3
IF(AND) in an array formula 3
MATCH/IF/OR/AND statements not what I need apparently 1

Top