SQL.REQUEST Array Formula Help Needed

M

Matt

I need help with an SQL.REQUEST query I'm trying to run.

The data file is set up like this:

Number Name Value
111111 ABCD 345
222222 EFGH 456
333333 KLNO 984
444444 VXYZ 323

The sheet with the SQL.REQUEST looks up the number and returns the
corresponding value (the name is not used). However, the numbers are
not in numerical order (i.e., not in the same order as on the data
sheet).

If I do this as separate formulas for each number, it works fine,
however it takes a long time to calculate. Is there any way to do this
as an array formula?

I want to be able to get the following values via an array formula.

11111 value1
33333 value2
44444 value3
22222 value4

Any help would be appreciated.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Top