Report

Vlookup formula help please [Solved]

Ask a question redbaby 11Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Latest answer on Mar 22, 2016 12:50PM
=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22
Please everybody, how do I write this formula so as not to return error #value?
See more 
Helpful
+1
moins plus
Hi Redbaby,

There is nothing wrong with your formula, so it must be the values.

Is the 4th column of the AppMember range a number?
Is the value in E22 a number?

Otherwise consider posting a sample of what you have.

Best regards,
Trowa

redbaby 11Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Mar 22, 2016 04:07AM
Hello Trowa,

Thank you for your time and effort to help.

=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22


Yes the 4th column of AppMember range is a number and the value E22 is also a number but the problem I think is the fact that column D of PaymentDetails is vlookup.

That is to say column B of PaymentDetails is validated members name to vlookup members monthly savings of say 10,000 in column D from another sheet, now if the member pays for say two months the formula will multiply the 10,000 by column E(E22) and return 20,000 in column D and this is correct but all the empty cells are returning the error #value.

Thanks once more, I hope I'm able to make you understand.
Reply
Add comment
Helpful
+1
moins plus
Hi Redbaby,

If I understand you correctly you want to display nothing instead of #value.

Try this:
=IF(OR(PaymentDetails!$B22="",ISERROR(VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))=TRUE),"",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22

Best regards,
Trowa
redbaby 11Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Mar 22, 2016 12:33PM
Thanks a lot,more grace for increase in areas where you desire increase.

Please I need you to advice on the book to read to improve my excel formulas and macros skill.
Reply
TrowaD 1989Posts Sunday September 12, 2010Registration date ModeratorStatus September 27, 2016 Last seen - Mar 22, 2016 12:42PM
Never read a book about Excel. Google searches, trial/error and ccm.net is what developed my skills.
Reply
redbaby 11Posts Monday March 21, 2016Registration date March 24, 2016 Last seen - Mar 22, 2016 12:50PM
Thanks I appreciate
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!