Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Bongard" wrote in message
...
I went the direction of writing a quick macro to import the data and
copy down the cells in column A. I then created some lookups with the
format If(columnA="Ptfl",If(columnB="Size",columnC))). This seems to
be working just fine.

thanks for your help,
Brian