Work
Center Lot# Cat#
CNV1 0230249 1110
KOCH 0210211 1443
DV2/1* 0220678 1539
DV2/1* 0220699 1540
DV3 0220674 1797
DV2 0220684 298
DV3 0220726 2544
#VALUE! 0285050 4060AS
#VALUE! 0285053 4067AS
#VALUE! 0285047 8242A
The user will input the Lot# in and the workcenter and cat# will be looked up. There are several more columns that do lookups based on either the cat#, lot# or workcenter.
Formula for workcenter is:
=IF(C2="","",VLOOKUP(VALUE(C2),sd2,3,FALSE))
for cat# was:
=IF(B2=0,"",VLOOKUP(B2,lotsearch,2,FALSE))
for cat# now:
=INDEX(lotsearch!$B$1:$B$187,MATCH(B2,lotsearch!$A$1:$A$187,0))
This works in the cat# column but now I must change all my other formulas which are also vlookups.
Any help is greatly appreciated!