Column J supplier codeOn 2002-04-11 01:38, markbanin wrote:
Thanks Brian
But I really need to keep the address on seperate rows.
Mark
On 2002-04-11 01:57, Brian from Maui wrote:
On 2002-04-11 01:38, markbanin wrote:
Thanks Brian
But I really need to keep the address on seperate rows.
Mark
How about separate columns i.e column k street
Column l city
Column m state etc.
Then on another sheet or somehwere on the same sheet just refer to the preceding column
In B1 =vlookup(a1,range,2)
In c1 = vlookup(b1,range,3)
In d1 =vlookup(c1,range,4)
enter supplier code in A1
or PM your email, I'll send a sample spreadsheet
This message was edited by Brian from Maui on 2002-04-11 02:00
On 2002-04-11 02:02, Aladin Akyurek wrote:
On 2002-04-11 01:57, Brian from Maui wrote:
On 2002-04-11 01:38, markbanin wrote:
Thanks Brian
But I really need to keep the address on seperate rows.
Mark
How about separate columns i.e column k street
Column l city
Column m state etc.
Then on another sheet or somehwere on the same sheet just refer to the preceding column
In B1 =vlookup(a1,range,2)
In c1 = vlookup(b1,range,3)
In d1 =vlookup(c1,range,4)
enter supplier code in A1
or PM your email, I'll send a sample spreadsheet
This message was edited by Brian from Maui on 2002-04-11 02:00
Brian,
On your proposal,
B1 =vlookup(a1,range,2)
c1 = vlookup(b1,range,3)
d1 =vlookup(c1,range,4)
should be:
B1 =vlookup(a1,range,2)
c1 = vlookup(a1,range,3)
d1 =vlookup(a1,range,4)
Aladin
On 2002-04-11 01:10, markbanin wrote:
I want to look up a supplier code in column A
and have it return the Address in column C (which occupies 6 rows). When I use VLOOKUP it will only give the corresponding SINGLE row.