VLOOKUP.... I think

[NEED HELP]

I have a worksheet with 5 columns and need to knwo if I
can look info from a middle column and display all other
column info. I have different people looking up differnet
things.

EX....

part# Process # Descrip loc Stock
3-58 89512454 part B-2 100
5-89 98656544 PART G-56 63

can I look up Process # and display other four?

 

[JE McGimpsey]

ONe way:

Assuming columns are A:E:

part#: =INDEX(A:A,MATCH(Process#,B:B,FALSE))
Descrip: =VLOOKUP(Process#,B:C,2,FALSE)
loc: =VLOOKUP(Process#,B,3,FALSE)
Stock: =VLOOKUP(Process#,B:E,4,FALSE)