Forum Discussion
azmxmlk
Mar 29, 2022Copper Contributor
IF and VLOOKUP
Hi, I am working on a project where I am trying to populate a value from a table (that is being queried into the workbook from an external source). Ex: If I type in the State value as 'NY' - I nee...
azmxmlk
Mar 29, 2022Copper Contributor
So the state abbs are in B2:B52 - what's D52 doing here - I m confused - was it a typo?
HansVogelaar
Mar 29, 2022MVP
Yes, sorry, a typo.
"and the corresponding Power $/kWh in E2:E52." should have been "and the corresponding Power $/kWh in D2:D52.