| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup data and fill cells
I have 1 sheet that has a column containing many different account numbers.
I have a 2nd sheet with the same account numbers with the relevant account name. I would like to add a column on the 1st sheet which looks up the account number on the 2nd sheet and brings back the account name. Both sheets have varying numbers of rows which change from month to month. The 2nd sheet has all possible account numbers, and the 1st only has account numbers used that month. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill blank cells with cells above data | Excel Worksheet Functions | |||
| Fill down formulas in cells to the LEFT of external data range? | Excel Worksheet Functions | |||
| Fill formulas into adjacent cells does not take formula only data | Excel Worksheet Functions | |||
| Can I sort excel spreadsheet data by fill color of cells? | Excel Discussion (Misc queries) | |||
| How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
