Need help on search and sort.

[kishorkhanal]

I have text and numbers in random order in columns A to D. In column E I have the same values as in A but in a different order. Now, I want the rest of the values from B to D in columns F to H but the order should be as in E. For example value in A5 is in E10. Now I want B5, C5, D5 values in F10, G10 and H10 respectively. Is there any formula for this purpose. I tried Lookup, vlookup, match etc but didn't work.

 

[Jonmo1]

vlookup...

F10 formula
=Vlookup(E10,A:D,2,False)

G10
=Vlookup(E10,A:D,3,False)

H10
=Vlookup(E10,A:D,4,False)

 

[Lewiy]

In E1 put:

=VLOOKUP($E1,$A$1:$D$10,COLUMN(B1),FALSE)

Then copy E1 and paste it into all the other cells in columns E, F & G.

 

[kishorkhanal]

I am still having some problems. Will this formula work if I have empty cells in columns A and E.

 

[Jonmo1]

Yes, blanks should not be an issue.

If it's not working, it's likely that you have "Numbers Stored as Text) in column A. To resolve this, type a 1 anywhere on your sheet, copy it. Then highlight column A, paste special - values - multiply.

You might also want to check column A for EXACT match to What is in E10. Look for trailing/leading spaces.

Edit...do those steps to BOTH columns A and E.