Hi there, I have found several functions (like LOOKUP) that will do this for values, but not text.
I have two sheets. The only commonality between them is a name. THere are about 400 names. Sheet 1 has name + salary. Sheet 2 has name + hours. How do I get name + salary + hours for the correct name into one spreadsheet?
Pls upload a sample workbook to work on
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Use vlookup, just put a zero as the last argument. For example:
Formula:
Please Login or Register to view this content.
It will search the value (e.g. name) found in A1 in column X and return the corresponding value in column Y. The last argument being zero means that it has to be an exact match. I have a thread dedicated to this called Advanced VLookup. It contains lot of examples and turn-key solutions.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
This works perfectly thank you so much! abousetta!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks