Hi,
I have the following headers for my sales report which looks at sales of
spare parts. The column headers are from A1 to N1, I have shown a small
example, not all columns. I need to enter the fomula in column M.
I was using
=VLOOKUP(+E2,'[PARTS CATEGORY 1.xls]Sheet1'!$A$2:$C$69,1,TRUE)
Which worked for the first row but then the other rows just seemed to
select any product category.
Customer Order No Invoice No Class Part Number
1 180077 324752 40 GP2SPSXX00021
10082 170926 310216 40 SCNDORXX00067
10116 164529 300791 40 SYCOMNXX00074
I need to look up Part number in another workbook which cantains a start
range and end range for eaxample
CATEGORY START END
ARDAC T0000000001 T9999999999
ARDAC ELITE ARDACECB00001 ARDACECB99999
ARDAC ELITE B5EC01XX00001 BE5S03XX99999
ARDAC ELITE SARDELXX00001 SARDELXX99999
ARDAC5 BA5C01AA00001 BA5S01ZZ99999
CONDOR SCNDORXX00001 SCNDORXX99999
CONDOR SCPLUSXX00001 SCPLUSXX99999
CONDOR SCPREMXX00001 SCPREMXX99999
Hope I have given you enough info. Thanks
winnie123 said:
Can anyone help? I have a worksheet containing part numbers and I want to
search another workbook which contains a product category. The trouble is the
product category only shows the first part number and last part number,its
not a full list. How can I use look up to return the product category?-Hide quoted text -
- Show quoted text -