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?



--
Eric

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
differs.

Hope this helps.

Pete

On Jan 15, 4:17*pm, Eric D wrote:
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?

--
Eric

You want an INDEX(MATCH() more than likely.

Read up on them he
http://skp.mvps.org/xl00002.htm
http://support.microsoft.com/kb/214142

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Eric D" wrote:

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?



--
Eric

Thanks that works well for what i needed
--
Eric


"JBeaucaire" wrote:

You want an INDEX(MATCH() more than likely.

Read up on them he
http://skp.mvps.org/xl00002.htm
http://support.microsoft.com/kb/214142

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Eric D" wrote:

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?



--
Eric