You could always use the versatile index/match to look up on any col, and
return any other col to the left/right of the match col

Try Debra's nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,400 Files:356 Subscribers:53
xdemechanik
---
"FullCity Consulting Inc." wrote:
I am using a workbook connection to pull data from a sql source into a
worksheet. Is there any way to define what order the columns are ordered in
the resulting array? I'd like to be able to put my primary key in the
leftmost column ("A") so I can lokup data using that key in a VLOOKUP
function.

Thanks!
--
Adam Aronson

FullCity Consulting Inc.
Certified FileMaker Developer
Platinum FileMaker Business Alliance Members
2007 FileMaker Partner of The Year