A=B B=C how do I find which A = C?

Closed
Ryan - Apr 19, 2010 at 08:07 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 19, 2010 at 08:12 AM
Hello,

I have tabular outputs of two data sources and I need to match the data together.

Each set contains two columns and can be pasted into one sheet and would like like such:
UserID BankID UserID Cluster ID

I need to find the BankID that matches the ClusterID linked by the comon UserID. All of these values contains a mix of text and numbers. Is there a formula that I can use that would match the UserIDs and write the BankID that matches the ClusterID? I've been searching online and fiddling with Excel for days now and would really appreciate any help I can get.

Thanks in advance,
R

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Apr 19, 2010 at 08:12 AM
It seems that you need VLOOKUP . Lets say you want to search for BANKID in cells B2

in in B2 have this formula

=VLOOKUP(a2, C:D,2, false)

Basically formula is saying, check the value found in A2 in Column C, and if match is found, return me the value on the same row as in column D
0