taxi driver
New member
- Joined
- Aug 6, 2011
- Messages
- 3
- Reaction score
- 0
- Points
- 0
please help! here are the two formulas i would like to combine. both work standing alone, but i need them both to be in the same cell if that is even possible.
=SUMIF(Sheet2!B$2:B$20,"="&A18,Sheet2!D220)
=LOOKUP(2,1/(D220<>""),D220)
further explanation, (see attached workbook) when AMD is entered into A18 the result in cell d18 should be 5.00. when a ticker is entered that matches an entry in sheet2 then the latest data entry from sheet2 cell range d2:d20 should be pulled into the appropriate d column cell in sheet1. sheet2 is continually being added to i do not want a SUM, but only the latest corresponding price.
Thanks in advance if anyone can help
=SUMIF(Sheet2!B$2:B$20,"="&A18,Sheet2!D220)
=LOOKUP(2,1/(D220<>""),D220)
further explanation, (see attached workbook) when AMD is entered into A18 the result in cell d18 should be 5.00. when a ticker is entered that matches an entry in sheet2 then the latest data entry from sheet2 cell range d2:d20 should be pulled into the appropriate d column cell in sheet1. sheet2 is continually being added to i do not want a SUM, but only the latest corresponding price.
Thanks in advance if anyone can help