sararose27
New Member
- Joined
- Aug 20, 2018
- Messages
- 8
I could use some help setting up a vlookup that will be used in multiple cells in the same worksheet. The data is in a different tab in same worksheet.
The lookup value will be cell B5 in the sheet with the vlookup.
Table Array: AE 2019 eCAT Test Ppts ***do I need to remove spaces from tab name?***
Column Index: 13 ***this will change based on the data I need to pull***
Range Lookup: False.
I am hoping to come up with one row of code that I can copy/paste and just change the Column Index.
I tried
Dim EEID As String EEID = Range("B5")
ActiveCell.FormulaR1C1 = _
"=VLOOKUP("EID"'AE 2019 eCAT Test Ppts'!C[5]:C[52],13,0)"
It isn't working.
TIA
The lookup value will be cell B5 in the sheet with the vlookup.
Table Array: AE 2019 eCAT Test Ppts ***do I need to remove spaces from tab name?***
Column Index: 13 ***this will change based on the data I need to pull***
Range Lookup: False.
I am hoping to come up with one row of code that I can copy/paste and just change the Column Index.
I tried
Dim EEID As String EEID = Range("B5")
ActiveCell.FormulaR1C1 = _
"=VLOOKUP("EID"'AE 2019 eCAT Test Ppts'!C[5]:C[52],13,0)"
It isn't working.
TIA