MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 246|Reply: 3

how to use iserror and lookup functions

[Copy link]

1

Topics

2

Posts

7

Integral

Newbie

Rank: 1

Integral
7
Post on 12-18-2016 15:06:20 | All posts |Read mode
hi, i'm a s/w developer. i got a project to convert excel sheet to webpage type..
the problem is i don't know the logic's and function of excel. rite now i'm face with three issue.. abt iserror and lookup function and the other one is which is inside the iserror.
will show u the function here..
IF(ISERROR(DB(DB12,DI12,DJ12,$FN$11)),0,ROUND(DB(DB12,DI12,DJ12,$F$11),2)
HERE WHAT IS IERROR AND THE WITHIN THE DB(BRACES)..
NEXT IS
LOOKUP(DK12+1,$DL$11:$GW$11,DL12:GW12)
CAN ANY ONE HELP PLEASE




Reply

Props Report

0

Topics

9

Posts

22

Integral

Member

Rank: 2

Integral
22
Post on 12-18-2016 16:20:10 | All posts



Hi Ramminani,
Welcome to the forum!
IFERROR allows you to return the custom output you want to see when there is any error occurred.
e.g. =IFERROR(your formula,NOT FOUND)
Hope this is clear.
Regards,
AM






Reply Support Opposition

Props Report

1

Topics

2

Posts

7

Integral

Newbie

Rank: 1

Integral
7
 Author| Post on 12-18-2016 16:26:52 | All posts



what abt DB(DB12,DI12,DJ12,$FN$11) means???




Reply Support Opposition

Props Report

0

Topics

5

Posts

12

Integral

Member

Rank: 2

Integral
12
Post on 12-18-2016 17:40:01 | All posts
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-25-2017 11:45 , Processed in 0.194078 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!