locating a cell and taking the ifo from the cell next to it

[manickmj]

First I want to thank evryone that has helped me in the past. You guy
are great!!!


Here is my problem:

in column A I have all of my route numbers for work(1, 2, 3, ...
staright down the column. in column b I have what thier daily averag
wage is.

I also have "relief drivers" that fill in for these routes. In thie
payroll column I have what Route they worked (column d) with the pa
amount (Column E) to the right of that.

Can I have that cell in Column E find the Daily wage from column B b
reading what number is in column A(which would be the same as colum
d)?

I hope someone can understand what I am trying to say but it is hard t
explain.

Thank You very much
Mik

 

[RagDyer]

With labels in row1,
And data starting in row 2,
Enter this in E2, and drag down to copy as needed:

=VLOOKUP(D2,$A$2:$B$100,2,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


First I want to thank evryone that has helped me in the past. You guys
are great!!!


Here is my problem:

in column A I have all of my route numbers for work(1, 2, 3, ...)
staright down the column. in column b I have what thier daily average
wage is.

I also have "relief drivers" that fill in for these routes. In thier
payroll column I have what Route they worked (column d) with the pay
amount (Column E) to the right of that.

Can I have that cell in Column E find the Daily wage from column B by
reading what number is in column A(which would be the same as column
d)?

I hope someone can understand what I am trying to say but it is hard to
explain.

Thank You very much
Mike

 

[manickmj]

I have attached the form I am working on. what I need is a formula i
o6 - 020. I didn't realize that you could attach files to this. hop
this help

Attachment filename: book2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=58627

 

[Llobid]

manickmj...

I believe the following formula in column E will work. I have attache
a picture of the situation in case you want to make sure I hav
interpreted your situation correctly.

=LOOKUP(D2,$A$2:$B$6)

Copy (fill) the formula down and it should work.

PS: I believe your "Route Numbers" must be in sequential order for thi
formula to work

Attachment filename: lookup formula.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=58627

 

[Guest]

Yes, you can use a lookup function to do this pretty easily. In cell E1 you could enter the following for example:

=VLOOKUP(D2,A:B,2,FALSE)

That takes the value from cell D2 and then runs down column A looking forthe first instance of an exact match, then moves across and returns the relevant result from column B. In the formula, D2 is your lookup value, A:B is the range to look in, 2 says return the result from the second column in the range and FALSE says look for an exact match.

Hope this helps.