Vlookup with column name instead of col_index_name(3rd Section of Vlookup formula)

[akulka58]

In Vlookup can we used column name instead of col_index_name(3rd Section of Vlookup formula)? I do not want to use Match or Index within vlookup. I have attached sample file for your reference. Please advise.

[Kaper]

Please Login or Register  to view this content.

instead of "Name" you can use address of a cell with text Name

[Olly]

I do not want to use Match or Index within vlookup.

Why not? That would be the best way to refer to a column heading by name within a Vlookup:

Please Login or Register  to view this content.

[akulka58]

Hi Kaper,

Thanks for your reply. I need to use without MATCH or INDEX formula.

[Olly]

I need to use without MATCH or INDEX formula.

Please explain why?

[akulka58]

Trying to find out if there are any other way, if there are any other options let me know.

[Kaper]

Of course (it is not wise, but if you wish so) you can always use several IFs instead of MATCH like (in B1 your selected header like Name or date etc.). For instance:

Please Login or Register  to view this content.

[akulka58]

Hi Kaper, Thanks a lot lot but It showing NO Column Data. It should show NAME column data. Please advise.

[szbill62]

And another solution without MATCH or INDEX but with SUMPRODUCT (MATCH would be much better).

Please Login or Register  to view this content.

Cell B1 contain "name" or "date", of course.

[akulka58]

Hi Kaper & szbill62,

Thanks for your reply. The formula is not showing correct results. Its showing 1 only. If you can send me the file that would be better.

[Kaper]

No, I think if you can send us the file that would be better
You claim it is not working -> show us.
Frankly speaking, we do not care too much if you do not put enough effort ...

OK. That was enough - see the attechment.