Automatic cell fill

[vkuppa]

I HAVE 2 COLUMNS: 1) PART # AND 2)DESCRIPTION.

i WANT DESCRIPTION TO FILL AUTOMATICALLY IN COLUMN2 WHEN I ENTER PART # IN COLUMN 1.

I know this can happen by using IF statements could you please help me with this.

I have the data with part nos and descriptions in another sheet.

Looking forward for your reply.

Thanks,
Vishali.

[EdMac]

Hi

You need to use VLookup

=vlookup(match_part_no,table_with_parts_ and_description,Co_no_with-description,FALSE).

e.g.Vlookup(B2,Datasheet!A1:B100,2,False)

Ed

[Bryan Hessey]

Vishali,

you need to relax a little, don't PM me with 'notify on read' because I will not allow the response, and moreso when you PM me close to midnight don't expect a response.

There was also no reason to cross post the question in 3 places.

This is a Forum, Post your query in accordance with the Forum rules and wait for someone who feels inclined to offer a response.

Your query is not urgent to me so using the 'u' word or sending PM's gains you nothing except a bad reputation.

---