kishorkhanal
Active Member
- Joined
- Mar 23, 2006
- Messages
- 434
I have random values in column A. It is all numbers and texts mixed. From columns B to E I have values for the corresponding value in Column A. I want the values in column A sorted in some other order and rest of the values should also get sorted accordingly.
In column F I have same values in Column A but in the order I want other values from cells B to E to cells G to J corresponding to value in column A. I used Lookup function but didn't work.
This is an example. I come accross lot of values to be sorted. I want to automate to certain extent. I want formula in cells G to J so that whenever I enter values in order in cell F, all other corresponding values should show automatically, provided I have all the values already entered in cells A to E.
Any suggestions please.
In column F I have same values in Column A but in the order I want other values from cells B to E to cells G to J corresponding to value in column A. I used Lookup function but didn't work.
This is an example. I come accross lot of values to be sorted. I want to automate to certain extent. I want formula in cells G to J so that whenever I enter values in order in cell F, all other corresponding values should show automatically, provided I have all the values already entered in cells A to E.
Any suggestions please.