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

Assuming the description is in column B of the first worksheet, you
could do this in D2 of the second worksheet:

=IF(B2="","",IF(ISNA(MATCH(B2,Current!A:A,0)),"",V LOOKUP(B2,Current!
A:B,2,0)))

Copy down as required.

Hope this helps.

Pete

On Jul 23, 7:16*pm, Revned wrote:
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

Where is the description data located? If it's on the 2nd worksheet just use
a VLOOKUP like you did to get the drawing number. You'd just change the
column_index_number argument in the VLOOKUP function.

--
Biff
Microsoft Excel MVP


"Revned" wrote in message
...
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