Thinking...

Let us assume that you know a trait of the tables that allows you to
detect whether it has a vertical or horizontal orientation. E.g. you
know the label of the second column/row. Then you could have something
like

=IF(A2="label",VLOOKUP(...),HLOOKUP(...))

But the question is how you use these lookup functions. If you have
several such tables in several spreadsheets, how do you decide on
which sheet to look in the first place? Are you using INDIRECT? Also,
how do you specify the column (or row for HLOOKUP)?

You might have a central table where in the first column you have the
sheet name and table area and in the second column you have a V or H
to indicate the orientation. Say this range is called tables then you
might have something like:

=IF(VLOOKUP(F2,tables,2,0)="V",VLOOKUP(K2,INDIRECT (VLOOKUP(F2,tables,
1,0)),col,0),HLOOKUP(K2,INDIRECT(VLOOKUP(F2,tables ,1,0)),row,0))

In either case who decides col and row?

HTH
Kostis


On Jun 20, 4:31 pm, PerryK wrote:
The problem is that one of the data files is oriented to use VLookup and the
other is oriented to use HLookup.

I Need to figure out how to get the data from the table that is oriented for
VLookup into a table that could be used for HLookup.

Thanks

--
Perry K

"vezerid" wrote:
Probably you can do your job just using HLOOKUP instead of VLOOKUP.
HLOOKUP assumes an orientation that is typically transposed. Third
argument signifies row rather than column.

HTH
Kostis Vezerides

On Jun 20, 3:57 pm, PerryK wrote:
I have a file that I use the VLookup function to find the data from other
files.

The worksheet is set up with Lables in column "A" and the "names of
managers" across Row 1 - starting in Cell A2.

Some of my data files are set up with the "Names of the Managers" listed in
column A and then the data in column B.

Is there an easy way to do a Lookup and transpose the information.

Or is there a way to do a Paste Link and Transpose at the same time?

Thanks,
--
Perry K