VLOOKUP, IF and multiple columns
 

We have cutomers in Canada and US. In the Customer worksheet we have a column
(E) for the Postal Code and a column (AZ) for the Zip Code.

In my Suivi worksheet, I want to find the postal or the zip code for my
customer.

A B
C
CUSTOMER ID CUSTOMER NAME POSTAL / ZIP CODE
8198740412 9101-4886 QUEBEC INC.,
8198740412 9101-4886 QUEBEC INC.,
5168722070 A. GIMENEZ TRADING, INC.
4506556999 ACCES INGREDIENTS, INC.
6104319001 ACCESS PACKAGING, INC.

Postal code formula=VLOOKUP(A3,'[Suivi.xls]Customer'!$A:$E,5,FALSE)

Zip code formula=VLOOKUP(A4,'[Suivi.xls]Customer'!$A:$AZ,37,FALSE)

How can I merge the 2 fomulas with If or with IF(ISNA.

Thank you,

VLOOKUP, IF and multiple columns
 

try this idea
=VLOOKUP(F1,F2:H4,IF(VLOOKUP(F1,F2:H4,3)<1,2,3))
--
Don Guillett
SalesAid Software

"André Francoeur" <André wrote in
message ...
We have cutomers in Canada and US. In the Customer worksheet we have a
column
(E) for the Postal Code and a column (AZ) for the Zip Code.

In my Suivi worksheet, I want to find the postal or the zip code for my
customer.

A B
C
CUSTOMER ID CUSTOMER NAME POSTAL / ZIP CODE
8198740412 9101-4886 QUEBEC INC.,
8198740412 9101-4886 QUEBEC INC.,
5168722070 A. GIMENEZ TRADING, INC.
4506556999 ACCES INGREDIENTS, INC.
6104319001 ACCESS PACKAGING, INC.

Postal code formula=VLOOKUP(A3,'[Suivi.xls]Customer'!$A:$E,5,FALSE)

Zip code formula=VLOOKUP(A4,'[Suivi.xls]Customer'!$A:$AZ,37,FALSE)

How can I merge the 2 fomulas with If or with IF(ISNA.

Thank you,

VLOOKUP, IF and multiple columns
 

=IF(VLOOKUP(A3,[Suivi.xls]Customer!$A:$E,5,FALSE)<"",VLOOKUP(A3,[Suivi.xls]
Customer!$A:$E,5,FALSE),VLOOKUP(A3,[Suivi.xls]Customer!$A:$AZ,52,FALSE))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"André Francoeur" <Andr wrote in
message ...
We have cutomers in Canada and US. In the Customer worksheet we have a
column
(E) for the Postal Code and a column (AZ) for the Zip Code.

In my Suivi worksheet, I want to find the postal or the zip code for my
customer.

A B
C
CUSTOMER ID CUSTOMER NAME POSTAL / ZIP CODE
8198740412 9101-4886 QUEBEC INC.,
8198740412 9101-4886 QUEBEC INC.,
5168722070 A. GIMENEZ TRADING, INC.
4506556999 ACCES INGREDIENTS, INC.
6104319001 ACCESS PACKAGING, INC.

Postal code formula=VLOOKUP(A3,'[Suivi.xls]Customer'!$A:$E,5,FALSE)

Zip code formula=VLOOKUP(A4,'[Suivi.xls]Customer'!$A:$AZ,37,FALSE)

How can I merge the 2 fomulas with If or with IF(ISNA.

Thank you,

VLOOKUP, IF and multiple columns
 

why not just concatenate em together,if there is a zip code its shown if
there isnt its not
--
paul
remove nospam for email addy!



"André Francoeur" wrote:

We have cutomers in Canada and US. In the Customer worksheet we have a column
(E) for the Postal Code and a column (AZ) for the Zip Code.

In my Suivi worksheet, I want to find the postal or the zip code for my
customer.

A B
C
CUSTOMER ID CUSTOMER NAME POSTAL / ZIP CODE
8198740412 9101-4886 QUEBEC INC.,
8198740412 9101-4886 QUEBEC INC.,
5168722070 A. GIMENEZ TRADING, INC.
4506556999 ACCES INGREDIENTS, INC.
6104319001 ACCESS PACKAGING, INC.

Postal code formula=VLOOKUP(A3,'[Suivi.xls]Customer'!$A:$E,5,FALSE)

Zip code formula=VLOOKUP(A4,'[Suivi.xls]Customer'!$A:$AZ,37,FALSE)

How can I merge the 2 fomulas with If or with IF(ISNA.

Thank you,