Vlookup and Hlookup


Eric D

Is it possible to have a formula use both vlookup and hlookup together?

for example if i have a columns and rows that could change, but i have
labels in those that remain constant. Can i do a hlookup to find correct
column and then a vlookup to go to the right row to retrieve one value?


You can use MATCH to find the column number, like this:

=MATCH("Start date",1:1,0)

if your header is in row 1, but the start date column may vary. Then
substitute this (without the = sign) as the 3rd parameter of your
VLOOKUP. This assumes that the lookup column in your table is A, so
you may need to subtract a constant from the MATCH value if it

Hope this helps.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question