Multiple columns using same datatable to lookup values

CSmith_Dixonvalve

Hello everyone,

I have a sheet that stores part numbers / stock codes. There are 5 columns that have a part number.

The "master" part number list has 45K records, and I have successfully stored this as a datatable. I have also linked this datatable to one column in my sheet, using the stock code, to look up the description.

How do I use the same datatable to look up descriptions for the other four columns? I can only create one connection, and that locks it into one column. And using a lookup sheet doesn't work because we have 45K rows.

Can I specify a datatable in a VLOOKUP function?

Thanks in advance for your help.

Craig

Nick Korna

Can you post the headers of your columns?

I think it might be possible to do a (long) nested IF statement based on the "not found" portion of your formula - basically if the "not found" value is the result of doing your VLOOKUP, do a VLOOKUP on the next set of columns (obviously this wouldn't apply to the last one), if it isn't the result, then do the VLOOKUP normally to get the desired result.