Match Data in two comlumns and automatically fill column in a different sheet

[macki60]

1. I have two Columns -
2. Column A has Cutomer ID. All the customer IDs have a unique . 3456-101, 3456-102 there are abour 500 Customer ID
3. Column B has customer location-state information that corresponde to Customer ID like below
3456-101 GA
3456-102 TN
3456-103 GA
3456-104 MD

4. How can I get exel to associate the location with the customer ID and automatically fill the location information for the corresponding customer ID on a different sheet.

I hope I was clear in my description, any and all help is much appreciated. Thank you!

[dilipandey]

Hi macki60,

Try using vlookup function for this. Would suggest you to see the excel in-built help for vlookup. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[macki60]

Thanks I found this formula that works based on your suggestions...

If you input the customer ID in D2 and want to match it with the customer ID in A to the location information in B. Inser this formula in column E = =IF(ISNA(VLOOKUP(D2,A:B,2,FALSE)),0,VLOOKUP(D2,A:B,2,FALSE))

Thanks.