Maybe you have already checked it out, but I think you will need to do data blending. Look up for more information on that to see how it can help in your specific situation.
You can get started with these links.
You can also do a lookup if that solves your problem. So of the related function that could be worthwhile to know that go along with Lookup are found in this link.
Apologize if my response is too vague. Just wanted to try and help out in any way possible since I don't have specifics.
Hope this helps.
Thank you for suggesting data blending. I am going to try that but I will still need something like vlookup
Were you able to check the Lookup function in the link I had provided ?
yes I tried that before posting it here. May be I am making an error in my syntax. I will post here in case I get it right. Thanks