2-way lookup INDEX or any command

[Mattaak]

Hi friends

I am encountering problems with a 2-way lookup in my table .

How can i get the values when i have two fields that need to be matched from the parent table (original table) ?
The year column is not important at all but needs to be there.

original table

Meters Month Year R1
17-27A1 Oct 2009 R1 0.0006
17-27A1 Nov 2009 R1 0.0004
17-27A1 Dec 2009 R1 0.0006
17-27A1 Jan 2010 R1 0
17-27A1 Feb 2010 R1 0.0003
17-27A1 Mar 2010 R1 0.0008
17-27A1 Apr 2010 R1 0.0006
17-27A1 May 2010 R1 0.0009
17-27A1 Jun 2010 R1 0.0006
17-27A Oct 2009 T1 0.75
17-27A Nov 2009 T1 0.75
17-27A Dec 2009 T1 0.75
17-27A Jan 2010 T1 2
17-27A Feb 2010 T1 0.75
17-27A Mar 2010 T1 0.75
17-27A Apr 2010 T1 1
17-27A May 2010 T1 0.75
17-27A Jun 2010 T1 0.75
17-27H Oct 2009 K1 1
17-27H Nov 2009 K1 1
17-27H Dec 2009 K1 1
17-27H Jan 2010 K1 3
17-27H Feb 2010 K1 1
17-27H Mar 2010 K1 1
17-27H Apr 2010 K1 1
17-27H May 2010 K1 1
17-27H Jun 2010 K1 1



the table i need to be populated

final table or desired version
17-27A1 Jan Insert formula
Feb Insert formula
Mar Insert formula
Apr Insert formula
May Insert formula
Jun Insert formula
Jul Insert formula
Aug Insert formula
Sep Insert formula
Oct Insert formula
Nov Insert formula
Dec Insert formula
17-27A Jan Insert formula
Feb Insert formula
Mar Insert formula
Apr Insert formula
May Insert formula
Jun Insert formula
Jul Insert formula
Aug Insert formula
Sep Insert formula
Oct Insert formula
Nov Insert formula
Dec Insert formula
17-27H Jan Insert formula
Feb Insert formula
Mar Insert formula
Apr Insert formula
May Insert formula
Jun Insert formula
Jul Insert formula
Aug Insert formula
Sep Insert formula
Oct Insert formula
Nov Insert formula
Dec Insert formula


17-27A1,17-27H AND 17-27A should be in that particular one spot.

Thanks

Arend

[Richard Buttrey]

Hi,

Apart from Feb where it appears the answer should be .003 not .0025, use in C5

=INDEX('Parent Table '!D:D,MATCH(B5,'Parent Table '!B:B,FALSE),1)

and copy down.

Does that help?

[Mattaak]

Thanks a lot,but how can i do if there are more datasets present.

[MarvinP]

Hi Arend and welcome to the forum

See if the attached helps at all. It is just a different way of starting you data in a table format. I really don't know what formula you want in the yellow column.

[Mattaak]

Hi

This works for only one set of data,if the data is in this format how can i do a 2-way lookup :

I am going to reload the spreadsheet,I am new to this forum and i apologize if i confused you.