Match and Index function

[Eric Tsang]

Dear all
I am trying to use the function of Match and Index to do a table that can select the right "value"

I got a task in my company that I need to select the right price for the right date of the services

For example

July
1 - 3 July - US$10 , 4-9 July - US$12, 10 - 15 July - US$10

With the dates on one row and price on the next row. how can I make that work ?

Thanks

Eric

[JohnTopley]

Please post a small sample file showing expected results.

[JohnTopley]

You might be better having a price table with dates in column A and Price in B


01/07/2015 10
04/07/2015 30
10/07/2015 20

with date in F1 then

=VLOOKUP(F1,$A$1:$B$3,2)

will find price

use

=IFERROR(VLOOKUP(F1,$A$1:$B$3,2),"") to trap errors

[Beamernsw]

Here's an example of how HLookup would work, it might be easier then index/match.

Edit: Oops, shoulda refreshed. JohnTopley beat me again
Oh well.

[JohnTopley]

HLOOKUP is just as valid: I prefer data with columns as Headers and Rows as records.

[Beamernsw]

HLOOKUP is just as valid: I prefer data with columns as Headers and Rows as records.

Me Too John