Matching data

[Guest]

I have two columns with order numbers, if they match, I need to go to a third
column and put that information with the first order number.

So basically I have a row of data that needs to be updated with information
from a second location.

The data set that needs completion looks like this:
ACC Result MRN
00-000-0000 no virus
00-000-0001 flu
00-000-0002 no virus

The complementary data looks like this:
ACC MRN
00-000-0000 123456
00-000-0001 123457
00-000-0002 123458

The data is in no particular order. so I need to search from a list of about
1500 rows of data. I tried an if function, but couldn't figure out how to
compare one cell to a range, and the match function gave me an error. Thanks
for any help or new directions to try.

 

[mk]

I have two columns with order numbers, if they match, I need to go to a third
column and put that information with the first order number.

So basically I have a row of data that needs to be updated with information
from a second location.

The data set that needs completion looks like this:
ACC Result MRN
00-000-0000 no virus
00-000-0001 flu
00-000-0002 no virus

The complementary data looks like this:
ACC MRN
00-000-0000 123456
00-000-0001 123457
00-000-0002 123458

The data is in no particular order. so I need to search from a list of about
1500 rows of data. I tried an if function, but couldn't figure out how to
compare one cell to a range, and the match function gave me an error. Thanks
for any help or new directions to try.

it seems like a vlookup case. have you tried vlookup formula?

 

[Guest]

That worked thanks! I did have to change the data, it gave me an error at
first, because you can't have a constant as the lookup value. The dashes in
the sequence threw it off, but once I removed them, it worked.