CODEWITHSUNDEEP
excelexcel-formula
Abdallah Sakre
Abdallah Sakre

Reputation: 915

How to match an unsorted column in Excel

I have the below 4 columns. The "Name1 Sorted" is a group of values that are sorted, and the "ID sorted" is the id for each value. I have the same "Name1" but it is unsorted. How can I use Vlookup or any other way to match the "ID unsorted" to its corresponding "Name1 unsorted" column ?

enter image description here

Upvotes: 0

Views: 3183

Answers (3)

KUMAR
KUMAR

Reputation: 1995

you can also use vlookup() Function for exact match:

enter image description here

Upvotes: 1

Tom Sharpe
Tom Sharpe

Reputation: 34265

In this particular case you can also use vlookup:

=VLOOKUP(C2,$A$2:$B$8,2,TRUE)

enter image description here

Upvotes: 1

Harun24hr
Harun24hr

Reputation: 36880

Try Index/Match combination.

=INDEX($B$2:$B$8,MATCH(C2,$A$2:$A$8,0))

enter image description here

With Microsoft365 you can use XLOOKUP()

=XLOOKUP(C2,$A$2:$A$8,$B$2:$B$8,"No ID")

Upvotes: 2

Related Questions