Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching values
Newbie looking for code that would search column A find a matching value in
column C return the value found in adjacent column D to column B. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching values
Put this in B1 and copy down........
=VLOOKUP(A1,C:D,2,FALSE) Vaya con Dios, Chuck, CABGx3 "italiavb" wrote in message . .. Newbie looking for code that would search column A find a matching value in column C return the value found in adjacent column D to column B. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching values
Thanks a lot Chuck, It worked perfectly.
Pat "CLR" wrote in message ... Put this in B1 and copy down........ =VLOOKUP(A1,C:D,2,FALSE) Vaya con Dios, Chuck, CABGx3 "italiavb" wrote in message . .. Newbie looking for code that would search column A find a matching value in column C return the value found in adjacent column D to column B. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching values
Happy to help,..........and thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "italiavb" wrote in message . .. Thanks a lot Chuck, It worked perfectly. Pat "CLR" wrote in message ... Put this in B1 and copy down........ =VLOOKUP(A1,C:D,2,FALSE) Vaya con Dios, Chuck, CABGx3 "italiavb" wrote in message . .. Newbie looking for code that would search column A find a matching value in column C return the value found in adjacent column D to column B. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching numeric values. | Excel Discussion (Misc queries) | |||
Req help matching values across columns in Excel | Excel Worksheet Functions | |||
Get matching values and formulas from ajoining colums of dropdown | Excel Discussion (Misc queries) | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) |