DatePrice Lookup

[Parth007]

Hello Friendz...


There are 2 sheets.. 'Main' & 'Data'


'Main' Sheet have Date & range &
'Data' sheet have Date, Range, Price

Now the 'Main' Sheet should pull Price value from 'Data' sheet. marked in yellow..

Any one range for a particular date should have price value from 'Data' sheet..
Any formula will really help..

VBA is not allowed

[judgeh59]

does this help? put this in cell R2 and copy down

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[Faridwahidi]

Hi path,

You may use INDEX MATCH with multiple criteria

On the column R2, please copy paste this formula then CRTL+SHIFT+ENTER to enable curly braces {}

Please Login or Register  to view this content.

you may drag down the formula until the last row


If the code helped you please add reputation to me "*"

[BadlySpelledBuoy]

Formula added to the yellow cells to give the same result you manually input.

I'm making the assumption that you're looking for a multiple criteria lookup, as the costs could change even though the sample data doesn't do that.

BSB

[AlKey]

As a regular formula

Please Login or Register  to view this content.

[Parth007]

Superb.. Fabulous.. it worked in all cases thank you so much everyone !!!!