Hlookup example below .... where C9 is the cell you want to reference and C2
thru G5 is the range where the info is and 2 represents the number of columns
the lookup is going down.


=HLOOKUP($C9,$C$2:$G$5,2,0)

"Lscrivener" wrote:

I'm developing a time card with lists. When you pick a job, the corresponding
job number needs to come up. I've tried "If" functions but it seems to be
limited. I can't seem to grasp Hlookup. any help?