Vlookup formula help please
Solved/Closed
redbaby
Posts
11
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016
-
Mar 21, 2016 at 12:11 PM
redbaby Posts 11 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - Mar 22, 2016 at 12:50 PM
redbaby Posts 11 Registration date Monday March 21, 2016 Status Member Last seen March 24, 2016 - Mar 22, 2016 at 12:50 PM
Related:
- Vlookup formula help please
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 21, 2016 at 12:58 PM
Mar 21, 2016 at 12:58 PM
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 22, 2016 at 12:15 PM
Mar 22, 2016 at 12:15 PM
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
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
Posts
11
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016
1
Mar 22, 2016 at 12:33 PM
Mar 22, 2016 at 12:33 PM
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.
Please I need you to advice on the book to read to improve my excel formulas and macros skill.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Mar 22, 2016 at 12:42 PM
Mar 22, 2016 at 12:42 PM
Never read a book about Excel. Google searches, trial/error and ccm.net is what developed my skills.
redbaby
Posts
11
Registration date
Monday March 21, 2016
Status
Member
Last seen
March 24, 2016
1
Mar 22, 2016 at 12:50 PM
Mar 22, 2016 at 12:50 PM
Thanks I appreciate
Mar 22, 2016 at 04:07 AM
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.