Excel, if cell matches another cell then copy another cell

Asked Apr 20 '23 at 22:06

Active Apr 20 '23 at 22:06

Viewed 18 times

I have information of column A,D and E. I want to achieve result of column B

So I want a formula if any number of column A match any number of column E, the text on D column which is in same row as E number to moved on B column on right position.

*The numbers on all columns can't be reorder

edited Apr 20 '23 at 22:06

Scott Craner

148,073
10
49
81

asked Apr 20 '23 at 22:06

Toni Arton

1

INDEX/MATCH or XLOOKUP will do what you want. – Scott Craner Apr 20 '23 at 22:07
1

Or, `FILTER()` if you are in `MS365` or `Excel 2021/19` – Mayukh Bhattacharya Apr 20 '23 at 22:08
1

see: https://stackoverflow.com/questions/38641040/excel-vlookup-where-the-key-is-not-in-the-first-column/38641090#38641090 – Scott Craner Apr 20 '23 at 22:11
I have Excel 2010 so these formulas aren't available – Toni Arton Apr 20 '23 at 22:17
1

[INDEX()](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd) & [MATCH()](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a) are available in `Excel 2010` – Mayukh Bhattacharya Apr 20 '23 at 22:18
Please check the reference guide for the availability of **[Excel Functions](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb)** – Mayukh Bhattacharya Apr 20 '23 at 22:21
1

`=INDEX(D:D,MATCH(A1,E:E,0))` – Scott Craner Apr 20 '23 at 22:22
Just as an alternative to ^^^ --> `=VLOOKUP(A1,IF({1,0},E:E,D:D),2,0)` or `=VLOOKUP(A1,CHOOSE({1,2},E:E,D:D),2,0)` but are inefficient with respect to `INDEX()` with `MATCH()` --> Use `INDEX()` & `MATCH()` for better performance. – Mayukh Bhattacharya Apr 20 '23 at 22:25

Excel, if cell matches another cell then copy another cell

0 Answers0