Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What excel function to use?
I have a spreadsheet with Col A having unique customer numbers. Column D
also has the same customer numbers but in no particular order. Column E has a unique value associated with the number in Column D. I want to have the unique value associated with the same numbers in columns A & D placed in Column B. Is this possible? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What excel function to use?
B1: =VLOOKUP(A1,&D$1:$E$100,2,False)
and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Excel user" <Excel wrote in message ... I have a spreadsheet with Col A having unique customer numbers. Column D also has the same customer numbers but in no particular order. Column E has a unique value associated with the number in Column D. I want to have the unique value associated with the same numbers in columns A & D placed in Column B. Is this possible? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling a new function Excel gives me #NAME? | Excel Worksheet Functions | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) |