Hi Andrew:

I considered that but I wasn't certain how that would work in this case. Lance has a "one-to-many" situation where a single IC Item would have to locate multiple rows in the lookup file (whether it be Excel or a Named Item). Can he do that using Excel as a linked table? I'm not even certain that a Named Item can do it because I haven't tried it, but I think so.