Excel Excel Populating cells


Joined
Sep 7, 2012
Messages
2
Reaction score
0
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
 
Ad

Advertisements

alow

Excel Formulator
Joined
Mar 20, 2012
Messages
763
Reaction score
4
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top