J
JeffK
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, A1100
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, A1500.
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.
=VLOOKUP($A1,Sheet2!A1500,4,FALSE)
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 (column C).
Your help is appreciated.
Table 1 also has an "account size" ($) heading and the date column indicates
when the account was setup. Table is sheet1, A1100
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, A1500.
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.
=VLOOKUP($A1,Sheet2!A1500,4,FALSE)
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 (column C).
Your help is appreciated.