VBA Arrays and Interpolation

JMC_

New Member
Joined
Dec 12, 2005
Messages
2
Trying to make a spreadsheet to do the following:

I need to take a table of data from a sheet and load each of 5 columns into a seperate array. I want to then be able to give an arbitrary value into an input cell on one sheet and search its coresponding array in order to fill out the rest of the values that would be in the same "row" in the table if such a row were to exist.

I'm stuck on trying to figure out how to get this to work, and think I'm probably not even putting the data into arrays correctly. Would appreciate any tips/help.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,057
Office Version
  1. 365
Platform
  1. Windows
An applet?

Then surely you need a Java forum.:)

By the way is this linked to this.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,438
Messages
5,572,114
Members
412,441
Latest member
kelethymos
Top