function index & match

  • Thread starter Thread starter shital
  • Start date Start date
S

shital

I have data like
Job No. 582
acc name Total Exp.
Del-Order 795
Document 500
E.D.I Chgs 150

Job No. 563
acc name Total Exp.
Del-Order 795
Examination 580
E.D.I Chgs 150

Job No. 789
acc name Total Exp.
Del-Order 795
Document 500
E.D.I Chgs 150
Misc. Exp. 50


I want horizental like
when I type job no. it should take corsponding value from
list
Job No. Del-Order Document E.D.I Chgs
Examination Misc. Exp
It should lookup & match job no. with respective filed &
put the value
I try hlookup & match I am not getting the value
 
Back
Top