Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

**jpl69** · 03-30-2018, 01:52 PM

Hello,

I am trying to do a VLOOKUP in a different book. The basic VLOOKUP is simple. My problem is the results. Here is my issue.

Ok I have a report I'm building so we will call that Report. I am looking for information in Source.

I start in Report with a VLOOKUP but I need to return results from 1 of 3 columns. In other words I'm matching B2 with column 1 but I need to check each following column for results. Return column 3 if Column 3 is blank return column 5 and if column 5 is blank return column 7.

How can this be done?

**rlmh06** · 03-30-2018, 01:56 PM

Can you please attach a sample workbook?

**Sam Capricci** · 03-30-2018, 02:09 PM

if what you are saying is that you have a vlookup that looks one column and finds some items but not others then it would return #N/A as the result so it should look into a different column, etc. then something like =IFERROR(VLOOKUP(A4,Sheet2!$A$2:$C$20,3,FALSE),IFERROR(VLOOKUP(A4,Sheet2!$C$2:$e$20,3,FALSE),VLOOKUP(A4,Sheet2!$D$2:$F$20,3,FALSE)))
adjusted to your needs should work.

**jpl69** · 03-30-2018, 02:11 PM

Yes,

Please see attached files. As you will see in the source, there are three different contacts options. However, there are not always someone slotted in each position. I need to pull the most senior contact.

**Sam Capricci** · 03-30-2018, 02:55 PM

deleted, that won't do it based on your corrected info.
will have a different one in a couple minutes.

**Sam Capricci** · 03-30-2018, 03:06 PM

here you go...
=IF(AND(VLOOKUP(B2,'[source.xlsx]Sheet1'!$A$2:$C$7,3,FALSE)=0,VLOOKUP(B2,'[source.xlsx]Sheet1'!$A$2:$E$7,5,FALSE)=0),VLOOKUP(B2,'[source.xlsx]Sheet1'!$A$2:$G$7,7,FALSE),IF(VLOOKUP(B2,'[source.xlsx]Sheet1'!$A$2:$C$7,3,FALSE)=0,VLOOKUP(B2,'[source.xlsx]Sheet1'!$A$2:$E$7,5,FALSE),VLOOKUP(B2,'[source.xlsx]Sheet1'!$A$2:$C$7,3,FALSE)))
it appears to work with your examples.

**jpl69** · 03-30-2018, 03:14 PM

Thanks so very much!!! That's exactly what I needed.

**Sam Capricci** · 03-30-2018, 03:18 PM

you're welcome, and thank you for the rep!

Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

LinkBack

Thread Tools

Rate This Thread

Display

Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Re: Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Re: Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Re: Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Re: Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Re: Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Re: Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Re: Is there an IF STATEMENT to do a VLOOKUP with results based on various criteria

Thread Information

Users Browsing this Thread

Similar Threads

If statement with a followup If based on the results of the first in the same cell.

[SOLVED] Vlookup- multiple results for same criteria. how to solve issue??

Using vLookup based on results from a vLookup & returning an undetermined list

Vlookup with 2 Criteria using formula results and text

Count statement wtih multiple criteria only showing results for one criteria

Creating a list based on the results of an IF Statement

Vlookup using cell with results of if statement

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions