Hello,
I am looking to write a formula that does three things:
1. Vlookup that checks list A for an amount - returning amount if listed
2. Vlookup that checks list B for an amount - returning amount if listed
If my reference isn't in either list I want excel to complete an if statement to perform a calculation.
3. If Statement to complete a cacluation
Example attached.
Thanks for your help
give this a try....put this in Cell J3 and copy down
=IFERROR(VLOOKUP(G3,$A$2:$B$7,2,0),IFERROR(VLOOKUP(G3,$D$2:$E$7,2,0),H3*I3))
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Please delete this post.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
judgeh59's formula can also be written this way.
Formula:
=IFERROR(IFERROR(VLOOKUP(G3,$A$3:$B$7,2,0),VLOOKUP(G3,$D$3:$E$7,2,0)),H3*I3)
Last edited by newdoverman; 09-11-2015 at 06:02 PM.
glad I could help and thanks for the rep points....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks