0
+-------+---+--------------+----+
| A     | B | C            | D  |
+-------+---+--------------+----+
| Mark  |   | Hasan Shahed | 50 |
+-------+---+--------------+----+
| Hasan |   | Saif Alam    | 60 |
+-------+---+--------------+----+
| Kabir |   | Mark Islam   | 70 |
+-------+---+--------------+----+
| Alam  |   | Ena Sanu     | 80 |
+-------+---+--------------+----+
| Sanu  |   | Joes Kabir   | 100|
+-------+---+--------------+----+

I want to match A1 to column C. If matched, setvalue B1= corresponding values from column D

Expected Result will be like-

+-------+-----+
| A     | B   |
+-------+-----+
| Mark  | 70  |
+-------+-----+
| Hasan | 50  |
+-------+-----+
| Kabir | 100 |
+-------+-----+
| Alam  | 60  |
+-------+-----+
| Sanu  | 80  |
+-------+-----+

How can I do that on Excel?

2
  • Can you have two different Marks in column C?
    – Jerry
    Jun 26, 2014 at 13:17
  • All values of Col C are unique & don't have duplicate.
    – Tanzil
    Jun 26, 2014 at 13:20

1 Answer 1

0

You can use a VLOOKUP to do that, with a wildcard:

=VLOOKUP("*"&A1&"*",C$1:D$5,2,0)

* will match anything.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .