Previous Topic Next Topic

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

Closed
Ryan - Apr 19, 2010 at 08:07 AM
rizvisa1 Posts 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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