VLOOKUP.... I think

  • Thread starter Thread starter NEED HELP
  • Start date Start date
N

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?
 
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:D,3,FALSE)
Stock: =VLOOKUP(Process#,B:E,4,FALSE)
 
Back
Top