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



.