Sanjay has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Add the formula
Hi,
Currently I have a formula which is given below .
=IFERROR(VLOOKUP($D31,CPERepLookup,20,TRUE),"")
Now I have to add one more condition here and the confdition is that "if the value in column H is "Managed Asset Service" then value will be empty in the box".
please let me knwo how we can add this condition in to the existing formula.
Thanks & Regards,
Sanjay Sharma
RE: add the formula
Hi Sanjay,
Thank you for the forum question.
Are you sure this is a VBA question?
Try
=IFERROR(if($H31= "Managed Asset Service","",VLOOKUP($D31,CPERepLookup,20,TRUE),""))
If you are looking for a VBA solution you will have to use a If decision code.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: add the formula
Please first state which Training Course this forum post is about:
Giving me error "You've entered too many arguments for this function"
RE: add the formula
Hi Sanjay,
Sorry try:
=IFERROR(IF($H31= "Managed Asset Service","",VLOOKUP($D31,CPERepLookup,20,TRUE)),"")
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
