• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

More complicated Excel vlookup

In a previous questions

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27820774.html 
 
This was the lookup that solved that solution however I have two other needs:

=IF(ISNA(VLOOKUP(A4,wBPS!A:B, 2, FALSE) ),"",VLOOKUP(A4,wBPS!A:B, 2, FALSE) )

1. when the value in wBPS is blank I want text to say "PPM/No BPS"
2. when there is no match in wBPS the text should say "No PPM"
0
Matt Pinkston
Asked:
Matt Pinkston
1 Solution
 
Rob HensonIT & Database AssistantCommented:
=IF(ISNA(VLOOKUP(A4,wBPS!A:B,2,FALSE)),"No PPM",IF(ISBLANK(VLOOKUP(A4,wBPS!A:B,2,FALSE)),"PPM/No BPS",VLOOKUP(A4,wBPS!A:B,2,FALSE)))

Thanks
Rob H
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now