Get the content of a column based on the column value in excel

Question

By checking the value in answer column it should return content from that column here answer is C so it should get Delhi from column C and put it in output column

Sample

How `Output` is `Delhi`? In `D column` it is showing `none of the above`! — Harun24hr, Dec 29 '19 at 04:44

score 1 · Answer 1 · answered Dec 29 '19 at 04:48

1

You can use Index(), Match() combine, which are better than Vlookup(), HLookup().

=INDEX(B2:E2,,MATCH(F2,B1:E1,0))

answered Dec 29 '19 at 04:48

Harun24hr

30,391
4
21
36

I agree on the ["better"](https://stackoverflow.com/a/58436658/9758194) aspect. HLookup is just the more known one. – JvdV Dec 29 '19 at 09:45
Yes, depends on user choice.Goal is to solve the issue. – Harun24hr Dec 29 '19 at 11:09

score 0 · Accepted Answer · answered Dec 29 '19 at 04:16

As Davesexcel stated, it seems HLOOKUP could work.

Here is a Google Sheet using HLOOKUP with a formula that should work in Excel as well: https://docs.google.com/spreadsheets/d/1LaCqkcLpgiQ1cYZEUBSSYbJkOaht1A34Af1MlZJwIc0/edit?usp=sharing.

The formula I have as an example is:

=hlookup(F2,B1:E2,row())

Get the content of a column based on the column value in excel

Sample

2 Answers2