What’s the Excel formula?

I’d prefer to input part number in the cell within Excel and still have it recognition a description to the particular portion number.We’ve the part numbers going down a column.I’d prefer the criteria to auto-magically be recalled inside cell immediately towards right in the cell with the part quantity.Please help, if you can.

You could possibly want to make use of the vlookup function

Assume your own parts data is in sheet2, with all the part range in column ANY and part description throughout column B.The part number will not has to be an true number, it can also be something like a serial variety.Assume the data in columns A as well as B within sheet2 usually are:

numberXY1 “description involving part corresponding to numberXY1”
numberXY2 “description associated with part associated with XY2”
numberXZ10 “description involving part by using serial range numberXZ10”

Then about sheet1 you begin entering the partnumber, age.g.numberXY1 towards cell A2 and have the criteria displayed within cell B2, then you have to enter that VLOOKUP formulation into sheet1 mobile B2 while follows:

=VLOOKUP(A2, Sheet2! $A$1:$B$1000, 2, FALSE

*Note on above vlookup – I assumed you are going to enter element numbers inside rows ONE PARTICULAR to ONE THOUSAND in sheet 2 using the part range in column A and also the part description of each one part almost it throughout column B

** It appears Yahoo cuts from the last component to the VLOOKUP functionality.It have to just learn “FALSE)”.