VLOOKUP based on TWO lookup_values?

[Karthik-Excelsior]

Hi Excel experts,

I've a dataset like that one which you can see here

This is what I'm trying to accomplish,

- VLOOKUP a site's sales for two months - Jan & Feb from a given table of Sales entries for all the sites by months. Once you look at the trix I've mentioned above, you'll get a better context.

I want to know if there is a better solution to this problem than my solution.

Any help is much appreciated!

Karthik

 

[scottylad2]

I'm not seeing any sample. Please add a sample or explain your layout

 

[Mindpsyche]

Try this:

Enter it with Ctrl+Shift+Enter, not just enter and drag across.

=INDEX($D$2:$D$5,MATCH(1,($C$2:$C$5=C$13)*($B$2:$B$5=$B14),0),)

 

[T. Valko]

I've a dataset like that one which you can see here

I'm not seeing any sample. Please add a sample or explain your layout

The word "here" is a hyperlink to a Google spreadsheet.

There's no contrast to hyperlinks that I can see (although I do have poor eyesight!).