vlookup backward
Sorry, still not clear.
OK the first reference array is
A B C
Dallas 1234 Bob J
Is that the data on Sheet1?
A b c
1234 Bob J Dallas
in in b1 I have =vlookup(a1, sheet 1 a1:c100,2,false)
Does A1 in the formula refer to 1234? If so, the formula won't work. The
lookup_value 1234 has to be in the leftmost column of the table_array sheet
1 a1:c100.
?????
--
Biff
Microsoft Excel MVP
" 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
.
|