LOOKUP value Help

[fhiOna]

Hi, I have this problem - Our manager told us to fuse 2 sheets, the First sheet named "VIABILITY" only has the Name of our members and its dependents. the second sheet "SERIATIM" - Name of members ( the same with viability ) and Contributions of MEMBERS only. my problem is - I want the contributions of the members in SERIATIM to be on the VIABILITY. Names of Members are not in alphabetical order. I have attached an example and I have tried LOOKUP, FIND, SEARCH but i can't get it pls help me with this deadline is on 3 days.
If Im not clear with my explanation pls let me know, This is my first post and Im hoping that somebody will help me with this . thanx

[Glenn Kennedy]

Before you can receive any help, you need to change your thread title. Use a phrase that tells us what the probem is (Google search terms). Telling us that you need help isn't informative!! Many folk search older replies for an answer to their problem. Your title wouldn't help them much!!

To change a Title go to your first post, click EDIT then Go Advanced and change your title.