Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I return multiple columns from a vlookup? | Excel Worksheet Functions | |||
vlookup for multiple columns | Excel Worksheet Functions | |||
Multiple Columns & VLookup?? | Excel Worksheet Functions | |||
VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
vlookup for multiple columns | Excel Worksheet Functions |