#1
|
|||
|
|||
Lookup columns
Hi there, is there a way of using the vlookup formula to pull the columns in the EM and PV tabs if selecting 2019 from the Main tab? Basically, if I were to choose 2019 from Main, A1 cell block, I'd like to pull the columns from EM and PV (columns E through G).
Perhaps there is a better way to do this. In the end, all i'm trying to do is gather the data from the tabs associated with 2019 into the Main tabe. Each year, there will be data to the right. Hope this makes sense. Thanks! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Lookup a value and modify a value x columns to right. | Gashmore | Excel | 1 | 11-08-2016 04:34 PM |
LOOKUP - Complex lookup with 2 lookups in 1 cell | sglandon | Excel | 6 | 05-05-2016 09:44 AM |
Lookup | Tony Singh | Excel | 3 | 03-06-2015 11:03 AM |
Lookup | angie.chang | Excel | 1 | 07-27-2012 09:45 PM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |