vlookup with two lookup values

**Vans1128** · 05-14-2010, 12:03 AM

Hi,

I need help and advise on how I can reference to two values using vlookup?
I have attached the example.

I need to reference from two lookup values. First is the date, next is the parameter depending if it is 2400, 0600, 1200 or 1800. The matching return value should be from column "swell height /dir"

Example 1:
Date Look up value is 28-Apr-10 and Parameter is 0600H. The return value should be 3.

Example 2:
Date Look up value is 29-Apr-10 and Parameter is 1800H. The return value should be ddd.

**protonLeah** · 05-14-2010, 12:14 AM

Please attach a workbook. JPG's cannot be copied into Excel as data.

**Vans1128** · 05-14-2010, 12:20 AM

Hi ProtonLeah,

Okays. I have attached the workbook.

**teylyn** · 05-14-2010, 12:35 AM

You need to fill the dates into each row, no blanks. Then you can use somthing like this:

=INDEX(E:E,MATCH(H1&H2,INDEX(A:A&B:B,0),0))

where H1 has the lookup date and H2 has the lookup Parameter

**Vans1128** · 05-17-2010, 08:27 PM

Thank you teylyn! It works.

I now have two sheets. The summary sheet where the formula is applied to 20 different cells.
And the second sheet, acting like a database, where the cells reference all of its values from. Somehow everything started to lag. Is it normal? or is there a more efficient manner to go about this?