# VLOOKUP Criteria

#### Tom McLernon

##### New Member
I am trying use VLOOKUP to import data from a target column in one sheet to a corresponding destination column another sheet when there is an indexed column match in each sheet.

And also put an exclusion on the data import IF there is a date value (any value) in a corresponding cell in a non-indexed H column. Basically even when there is a match on the indexed criteria, ignore the import or import "" from any line that has a date value in that column. The second part of this string seems to work, but the first part does not, will not ignore data import from the "condition met" H column lines.

=IF('Employee Schedule Filter-List'!\$H\$12:\$H\$1000<>"",IFERROR(VLOOKUP(\$C\$3:\$C\$1000,'Employee Schedule Filter-List'!\$A\$12:\$J\$1000,10,TRUE),"NO SCHED"))

Thanks,
Tom McLernon

### Excel Facts

Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

#### jorismoerings

##### Well-known Member
Hi Tom,

Your info is a bit minimal but just from looking at your formula.
I have some serious doubts if the second part of your formula will result in correct answers but that wasn't the question

you need to align the VLOOKUP with the exclusion part of the formula.

so try this:
=IF(ISBLANK(VLOOKUP(\$C\$3:\$C\$1000,'Employee Schedule Filter-List'!\$A\$12:\$J\$1000,8,TRUE)),IFERROR(VLOOKUP(\$C\$3:\$C\$1000,'Employee Schedule Filter-List'!\$A\$12:\$J\$1000,10,TRUE),"NO SCHED"))

#### Tom McLernon

##### New Member
Thanks jorismoerings,

This returns a "FALSE" value whether the source cell has a value or not. If only the second part of the string is used it brings in the correct value. The first part of the string is intended to ignore the record row if the specified cell has a value, because there may be more than one record where the \$C\$3:\$C\$1000 match statement is true.

I read where VLOOKUP can only have single condition statement, but others are indicating that there is a work-around to that.
Basically the string statement is attempting (first part) Ignore the record if this condition exists, and (second part) Import the cell value if this condition exists. (second part) works on its own, but any form of (first part) that I have tried produces a FALSE statement.

#### jorismoerings

##### Well-known Member
Hi,

Share a short sample of what your doing and want to establish.
Perhaps the forum (or i) can work out a solution for you.

#### Tom McLernon

##### New Member
jorismoerings,

It appears that I cannot post attachments which restricts any illustration possibility. Basically the workbook has three tabs, the common data in each sheet is "employee name". The "master" sheet is the hiring information where personal info and start date etc. is completed.
In another tab (sheet) the employee is assigned to an "occupation", a "workgroup", and a "schedule pattern". The "schedule patterns" have start dates and end dates and an employee may be assigned to several different "schedule patterns" over a period of time. It is intended that the "occupation", "workgroup", "schedule pattern" information be pulled into the Master sheet without data entry duplication. (by name match) And that only the current data be pulled in, which means ignoring any record in the scheduling sheet that has an end date.
The same would apply to the third tab which contains "accommodation" and "Air Flight" information, and data would also be pulled into the Master sheet, but also only "current" records. (ones that don't have an end date) (a blank cell in the end date column) The appropriate data is completed in each sheet, but all is collected in the Master sheet, also the Master would then indicate employee hires that had not been full processed by absence of data in the Master.

Thanks,
Tom McLernon

Replies
0
Views
384
Replies
4
Views
363
Replies
3
Views
1K
Replies
5
Views
846
Replies
0
Views
1K

1,191,549
Messages
5,987,221
Members
440,085
Latest member
MBecker79

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back