IF ERROR FORMULA

[Candida]

I am getting the result of "0" when there is data in row 20 that needs to be
comming through instead. for instance

Sheet 3-16
A2 V20
Piper 8155907568

Sheet 3-9

A2 V20
Piper "blank"

New Sheet

A2 V20
Piper "0"

(when stating the formula as you
proposed)=IF(ISNA(VLOOKUP(A2,'3-16'!$L$2:$BF$1538,20,FALSE)),VLOOKUP(A2,'3-9'!$L$2:$BF$1498,20,FALSE),0)
Please help.

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[new1]

      If desired, send your file to my address below. I will only look if:
      1. You send a copy of this message on an inserted sheet
      2. You give me the newsgroup and the subject line
      3. You send a clear explanation of what you want
      4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software












- Afficher le texte des messages précédents -

Hello,

The stated formula seems to be working like this :
if (ISNA(first_vlookup);2nd_vlookup; 0)
A test is performed with the first vlookup - the one which looks for
the value in A2 in the first column of the specified range ('3-16'!$L
$2:$BF$1538) - :
- if it does not find a matching value , the vlookup returns #N/A and
the IF statement then returns 0
- else the vlookup does not return #N/A and goes to the 2nd vlookup
(test another block looking a matching value for A2 ) .

Does it match with the data in your file ?

Hope this helps

new1@[no/spam]realce.net