Matching data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

it seems like a vlookup case. have you tried vlookup formula?
 
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.
 
Back
Top