vlookup or index/match formula??


T

Tdub

I am trying to us a vlookup formula which is a little more dynamic than just
a vlookup...I am looking to return sales figures for a given product accross
several months.

a b c d
1 Jan Feb Mar
2 prod A 10 20 30
3 prod B 5 15 6
4 Prod C 5 1 13

The current formula is: VLOOKUP($A7,$A$2:$D$4,2,FALSE)
Is there a way to change the index column to account for the change in
month, without having to just change the column from 2 to 3 to 4 as I move
accross months...can I add some other index or match, to match the month name
and return the matching value that cooresponds with the related month?
 
Ad

Advertisements

M

Mike H

Hi,

If you cjange your formula to the one below and drag right the column number
increments

=VLOOKUP($A7,$A$2:$D$4,COLUMN(B2),FALSE)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Ad

Advertisements


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

Top