Tom McLernon
New Member
- Joined
- May 18, 2016
- Messages
- 34
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
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