View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Astucchi Astucchi is offline
external usenet poster
 
Posts: 2
Default 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.