Merging two data tables together using Lookup function

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, 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top