hi,

Try this

=vlookup($A2,sheet1!$A$2:$C$101,match(C$1,sheet1!$ A$1:$C$1,0), false)

In sheet1, give columns heading in row 1. So the range would become
A2:C101. In sheet2 also, give the headings in row 1. So you will write
your formula in row 2.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

" wrote in message
...

OK the first reference array is
A B C
Dallas 1234 Bob J

On the next sheet the colums have to be in this order, no other allowed by
the company

A b c
1234 Bob J Dallas

in in b1 I have =vlookup(a1, sheet 1 a1:c100,2,false)
no probem
then what nexy??????

in c1 =vlookup(a1, sheet 1! A1:c100,????????????, false)

I can not change the order of the colums and sheet one is were data is
added
this multi sheet work book


"T. Valko" wrote:

It's not real clear what you want to do.

how do I go brackwards

Backwards from what?

What do you want to lookup?

--
Biff
Microsoft Excel MVP


" wrote in
message
...
col A the city were the employee located,
col B the emploee #1234
Col C the employeee name

OK simple vlookup right,

well on sheet 2 the data is different
col A agent #
Col B agent Name
col C agent city

how do I go brackwards



.