ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   look up and match exact data is adjacent column (https://www.excelbanter.com/new-users-excel/245619-look-up-match-exact-data-adjacent-column.html)

Craig

look up and match exact data is adjacent column
 
I am trying to import notes from a current data base program, which I
exported into excel, into a new database program which requires me to match a
unique case senstive ID (alpha & numeric) to an list of corresponding account
numbers from the existing database. To be clear, both databases contain the
same list of account numbers, but only the new database has the required
unique case senstive ID, which is why I need to match it with the old
database info.

I had partial success using the Lookup function, but it would not provide an
exact match.
A sample of my work can be seen below.
A B C D
1 Acct. # 1 ID Acct. # 2 Notes
2 15001 00180YlfSH 11923 Met Cathy
3 15002 00180YlFwK 12559 Met John
4 11923 00180YlFsH 15001 See Cindy
5 15023 00180YlFzV 15002 Signed form
6 15031 00180YlFtJ 15002 secured keys



Luke M

look up and match exact data is adjacent column
 
Instead of using LOOKUP, use the VLOOKUP function, with FALSE as the last
arguement (to ensure an exact match)

Example:
=VLOOKUP(A2,TableOfDate,ColumnOfDataYouWant,FALSE)

See the XL help file for futher detail/example.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Craig" wrote:

I am trying to import notes from a current data base program, which I
exported into excel, into a new database program which requires me to match a
unique case senstive ID (alpha & numeric) to an list of corresponding account
numbers from the existing database. To be clear, both databases contain the
same list of account numbers, but only the new database has the required
unique case senstive ID, which is why I need to match it with the old
database info.

I had partial success using the Lookup function, but it would not provide an
exact match.
A sample of my work can be seen below.
A B C D
1 Acct. # 1 ID Acct. # 2 Notes
2 15001 00180YlfSH 11923 Met Cathy
3 15002 00180YlFwK 12559 Met John
4 11923 00180YlFsH 15001 See Cindy
5 15023 00180YlFzV 15002 Signed form
6 15031 00180YlFtJ 15002 secured keys




All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com