Support Board
Date/Time: Mon, 12 May 2025 10:58:51 +0000
Post From: Spreadsheet Study for trading Question
| [2017-02-22 00:37:30] |
| Sawtooth - Posts: 4214 |
|
Here's one way: =IF(K3,Q3,S4) Where the formula in is S3, the lookup is in column Q, and the entry is in column K. Here's another way that gives the same result: =INDEX(Q3:Q1002,MATCH(1,K3:K1002,0),1) This doesn't have to be in a Formula Column if you only need the most recent entry's corresponding value, and you only need the value in one non-repeating cell. |