function index & match

[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

 

[David McRitchie]

Hi shital,
Are those two cell shown on each row?

Take a look at Snake Columns
http://www.mvps.org/dmcritchie/excel/snakecol.htm#dbdata