Index, Match, it's all Greek to me!

[Anne Troy]

I finally got this to work:

=IF(ISBLANK(D6),"",INDEX(hotelprice,MATCH(D4,hotel,0),MATCH(F2,seasonnumber,0)))

Now, here's what I need.

I need to add that if the value of D6 is greater than 1, I want to add *3* to the value in D4 and THAT's the column I want to return. In other words, D4 currently says 3, because that's the heading I want it to find the value (price of a night's stay) under. Now, have headings 1 through 6. 1 through 3 represent 3 variations (seasons) of the price the 1st night's stay. 4 through 6 represent the same 3 variations of the price of the 2nd night's stay.

I'm going to attempt to post my data momentarily.

 

[Anne Troy]

Merci beau coup, gracias, grazzi, and all those other languages I can really hack to death!

THANK YOU AGAIN, JAY.

 

[Anne Troy]

Oh, and just to let you know, it took me a good 30 minutes and j-walk's site to get the FIRST index/match!!

 

[Jay Petrulis]

Hi Dreamboat,

The first step is always the hardest.

I personally prefer INDEX/MATCH to any of the lookup functions. I feel it gives me the best control and flexibility.