Vlookup for two look up values

**alyaahmed** · 03-31-2013, 02:55 PM

Hello,

I am looking for a vlookup formula or any other formula that can work on two lookup values. I want the day to be directly shown after I enter the date. I attached an example worksheet to give you an idea of what I am looking for. I tried this formula but it doesn't work.

=IF(D9="","",IF(D10="","",VLOOKUP(D9:D10,A1:G3,3,FALSE)))

Thanks.

Alya

**martindwilson** · 03-31-2013, 03:03 PM

try
=INDEX(A3:G3,MATCH(D9&D10,INDEX(A1:G1&A2:G2,0),0))
mind you why not use date format cell dddd
=DATE(2013,D10,D9)
or
=TEXT(DATE(2013,D10,D9),"dddd")

**alyaahmed** · 03-31-2013, 03:13 PM

Thank you very much Martin D. Wilson. Your formula perfectly works. I will also try the other suggested formulas. I am a beginner at excel and I really value your suggestions and help. I am grateful to this valuable forum.