Vlookup for Stock price

[Adnan Haider]

If we have big database of daily stock prices with column of date,stock and price. How can we vlookup specific stock in specific date? On daily basis we have a large stocks list... Please solve this...

 

[Peter_SSs]

Welcome to the MrExcel board!

If the Date/Stock rows are unique, then try something like

=SUMIFS($C$2:$C$1000,A2:A1000,H3,B2:B1000,H2)

where prices are in C2:C1000, dates are in A2:A1000, date of interest is in H3, stocks are in B2:B1000, stock of interest is in H2

 

[Adnan Haider]

Thanks Peter for promt solution... But don't want sum of prices. If I have multiple items prices on daily basis... Then how can I know the specific item price on specific date... Thanks

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=INDEX(price,MATCH(dateofinterest,IF(stock=stockofinterest,date),0))

 

[Peter_SSs]

Thanks Peter for promt solution... But don't want sum of prices. If I have multiple items prices on daily basis... Then how can I know the specific item price on specific date... Thanks

If you have multiple prices for the same stock on the same day, how do we know which one to choose?
Did you try the suggested formula?

 

[Adnan Haider]

Yes... Didn't found result.

 

[Adnan Haider]

How can I share sample data

 

[Aladin Akyurek]

Yes... Didn't found result.

Did you try out the suggestion of post #4 at all?

 

[Adnan Haider]

Yes. But problem not solved.

 

[Adnan Haider]

How can I share my sample excel file?