ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   is it possible to find common data between to colums and match dat (https://www.excelbanter.com/excel-worksheet-functions/121039-possible-find-common-data-between-colums-match-dat.html)

Astucchi

is it possible to find common data between to colums and match dat
 
Example:

g1 g1 h2526
g5 g2 h2365
g9 g3 h2256

I have 400 items in one column that are not in the correct order but it is
the order they need to stay in. And I have another 2 colums that have the
data in order with an associated value. I need to take the values (h numbers)
and place them next to the corresponding "g number".

Any help would be great.

Thanks,
Tony.


All times are GMT +1. The time now is 10:03 PM.

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