Excel Excel Populating cells

[Miked1984]

I am currently undertaking a project where i want to reference a number to a description.

For example i have coded parts which are just numbers which need to tie into a description.

What i want to happen is if i type the number in A1 the description will automatically go into A2.

I have hundreds of different parts with different descriptions.

Is it possible to do this?

Thanks

 

[alow]

Do you already have a reference table that matches the parts and descriptions? If you do (lets say on a sheet named Reference in cells A1 through B100) you could use an IF statement with a VLOOKUP to show the description if something is in A1. Try the following formula in the cells you want to show the description in:

=IF(ISBLANK(A1),"",VLOOKUP(A1,Reference!$A$1:$B$100,2,0))

I'm just typing this in the reply here, so it may not be 100%. This also assumes that your reference table has the part numbers in column A and the descriptions in Column B. Let me know if this helps!