VB Script/Lookup

Advertisement


Question
Hello,

1- Table1 contains: Component
2- table2 contains : Component - Related Participant
Can I create a function that takeS the component in the first table to look for it in the second one in order to find the related participant ? Note that I can't create relationship between these two tables.
Thank you.
Maya

Answer
Hi Maya,

You can use VLOOKUP to get 2nd table component related participant without creating any function or relation.  I just come up with below example for your reference.


A        B       C       D
--------------------------------
sno   name   sno   name
2   mike   1   john
     2   mike
     3   mason


In above example I have given below formula in B2 cell
=VLOOKUP(A2,C2:D4,2)

Explanation:
I am looking for Sno 2 name from my other table (c2:d4).  Sno 2 should exists in other table to get corresponding value.  You can get more help from Excel itself.  Please let me know if you are looking something else.  Unfortunately I am not able attach this sample excel file for you.  If you are having trouble please suggest alternative how I can share this file with you.


Note: I am sorry for delayed reply, suffering from fever.

Thanks
Subbu.  

VB Script

All Answers


Answers by Expert:


Ask Experts

Volunteer


Subbu

Expertise

I can answer VB Script questions which are related to Visual Basic / VBA / QTP Scripts.

Experience

8 Years

Education/Credentials
Master of Computer Applications

Awards and Honors
Established Member from QA Forums and Brainbench certification

©2016 About.com. All rights reserved.