[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Excel Lookup with IF condition?

I have  Client List In ONE worksheet
Client List:
1234
2345
3456
4567

and Super Client in another Worksheet which MIGHT be the same number as a client..
1234
9876
8765
4567

In Workgroup 1 - I need to display Two Colums and MATCH the corresponding Super client..

Client  - Super Client
1234 - 1234

How can I achieve this in excel? Via a lookup? Example?
0
plucenko
Asked:
plucenko
  • 4
  • 4
  • 2
1 Solution
 
Joe OvermanEngineerCommented:
You can use a VLOOKUP.  see the attached file
ExampleBook.xlsx
0
 
AeridenCommented:
vlookup() works well for this kind of thing.  I have provided an example spreadsheet.  The first tab has the lookup data.  The setup tab uses the information and does the lookup.
Client-Lookup.xlsx
0
 
plucenkoAuthor Commented:
How do I get rid of n/a#
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
AeridenCommented:
There are a couple of ways to handle this (looking at cell B4 of the demo)...

=IF(ISERROR(VLOOKUP(A4,'Client Lookup'!$A$2:$B$28,2)), "", VLOOKUP(A4,'Client Lookup'!$A$2:$B$28,2))
 
This will get rid of all #N/A errors.  However, you may want the errors if there is indeed no lookup found, but only if something is specified.

=IF(A4="","",VLOOKUP(A4,'Client Lookup'!$A$2:$B$28,2))

This is probably the preferred method.  But thought it would be handy to know both.
0
 
plucenkoAuthor Commented:
What happens if I had the Super Client in one column instead of a sheet? How would i reference that... Thanks.
0
 
AeridenCommented:
I guess I am not exactly sure what you mean...  Do you mean instead of having two tabs, both are in one tab?
0
 
plucenkoAuthor Commented:
Yes
0
 
AeridenCommented:
Here is a new version with a single tab.
0
 
plucenkoAuthor Commented:
Can you attach the file - Thanks!!
0
 
Joe OvermanEngineerCommented:
Sorry for not getting back sooner and I am glad Aeriden as provided good answers while I was out.

The way VLOOKUP works is pretty simple.  I could spend coming up with a great explanation but MatthewsPatrick has great article on it.
  Six Reasons Why Your VLOOKUP or HLOOKUP Formula Does Not Work

Also attached is an answer to you last question.  If you award points I would give them to Aeriden.
ExampleBook.xlsx
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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