Forum Discussion
Pull Data From One Excel Sheet To Another Based on Lookup Values
Okay so let me preface, I am trying to make an excel spread sheet to track my option investments. To do so I would like to simply import my options data: stock symbol, prices, commissions, etc. Into ...
Oxley123 If you are on MS365 or Excel 2021, use the FILTER function (Cell C2). If that's not an option, you'll need to revert to a more cumbersome formulae (Columns E:F). Both are demonstrated in the attached file. I've used named ranges to make the formulae easier to write, read and maintain.
Alternatively, why not forget about the Search tab all-together? Do the search by filtering the desired symbol, directly in the transactions table.