Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging two data tables together using Lookup function
I have two tables which both include column headings: Branch, Account #, Date.
Table 1 also has an "account size" ($) heading and the date column indicates when the account was setup. Table is sheet1, A1:D100 Table 2 has "risk rating" heading and the date column indicates when the risk rating was calculated (not account setup as with Table 1). Table is sheet2, A1:D500. The issue is an account will only appear in Table 1 once, where it could appear 5 or 6 times depending how many times the risk rating was calculated. I was using a Vlookup in Column E on sheet 1 and it would bring the first risk rating that was listed for the account. What I would like to do is have the lookup to bring back the entry that was completed on or just prior to the account being setup. Your help is appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merging two data tables together using Lookup function
Tweak to the story...
I have two tables which both include column headings: Branch, Account #, Date. Table 1 also has an "account size" ($) heading and the date column indicates when the account was setup. Table is sheet1, A1:D100 Table 2 has "risk rating" heading and the date column indicates when the risk rating was calculated (not account setup as with Table 1). Table is sheet2, A1:D500. The issue is an account will only appear in Table 1 once, where it could appear 5 or 6 times in Table 2 depending how many times the risk rating was calculated. I was using a Vlookup in Column E on sheet 1 and it would bring the first risk rating that was listed for the account. What I would like to do is have the lookup bring back the entry that was completed on or just prior to the account being setup. Your help is appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up data validation and lookup tables...? | Excel Discussion (Misc queries) | |||
Merging data into pivot tables | Excel Discussion (Misc queries) | |||
Merging of pivot tables | Charts and Charting in Excel | |||
Merging 2 different pivot tables | Excel Worksheet Functions | |||
merging multiple pivot tables | Excel Worksheet Functions |