VLOOKUP Criteria

[Tom McLernon]

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

 

[jorismoerings]

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]

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]

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]

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