Ineed to know how to get data from one page to another i am using employee name and hrs worked on first sheet, i want to get the hourly rate from the second sheet which list employee name and pay rates then i want excel to calculate hourly rate times hrs worked should i use vlookup or what?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
using lookup feature
- Thread starter stellab
- Start date
Anne Troy
MrExcel MVP
- Joined
- Feb 18, 2002
- Messages
- 2,632
- Office Version
- 365
- Platform
- Windows
Probably. You can download a workbook all about VLOOKUP at:
http://www.thewordexpert.com/downloads.htm#MyVlookup
http://www.thewordexpert.com/downloads.htm#MyVlookup
Upvote
0
jarvis2323
New Member
- Joined
- Aug 11, 2002
- Messages
- 7
yes vlookup is the way to go, i use it for exactly the same purpose you described.
Formula would be something along the lines of: VLOOKUP(a3,Sheet2!$a$2:$b$21,2,FALSE)
Hope that helps
This message was edited by jarvis2323 on 2002-09-06 18:06
Formula would be something along the lines of: VLOOKUP(a3,Sheet2!$a$2:$b$21,2,FALSE)
Hope that helps
This message was edited by jarvis2323 on 2002-09-06 18:06
Upvote
0
Similar threads
- Question
