R
Revned
hello,
i have two worksheet in a spreadsheet
my first worksheet name Current
and 2nd is Previous
in column B of the 1st worksheet i have this
Drawing No
123456
765432
456789
in column B of worksheet 2 i have this
Drawing No
123456 123456
765432 765432
678904
234567 234567
now im using a vlookup formula and the result are place in column C of
worksheet 2 to find what are those Drawing No are
deleted and leave as blank cell if no match
now i want to populate the Description of each Drawing No in coulumn D of
worksheet2 if found match
Drawing No column D
123456 123456 Electrical equipment list
765432 765432 data sheets
678904
234567 234567 cable list
iam using excel 2003
thanks for any help i appreciate
i have two worksheet in a spreadsheet
my first worksheet name Current
and 2nd is Previous
in column B of the 1st worksheet i have this
Drawing No
123456
765432
456789
in column B of worksheet 2 i have this
Drawing No
123456 123456
765432 765432
678904
234567 234567
now im using a vlookup formula and the result are place in column C of
worksheet 2 to find what are those Drawing No are
deleted and leave as blank cell if no match
now i want to populate the Description of each Drawing No in coulumn D of
worksheet2 if found match
Drawing No column D
123456 123456 Electrical equipment list
765432 765432 data sheets
678904
234567 234567 cable list
iam using excel 2003
thanks for any help i appreciate