I have a workbook with 2 tabs
The 1st tab has the following info
A B C
Level Acct Dollars
1 3 AAAAA 1,631,276.63
2 2 BBBBB 8,879,065.02
3 1 BBBBB 86.57
4 3 BBBBB 234,986.25

The second tab has the following info:

A B C D
Acct Level 1 Level 2 Level 3
1 BBBBB
2 AAAAA
3 CCCCC


I want to combine a vlook up and an if statement to populate the above tab
to look like:

A B C D
Acct Level 1 Level 2 Level 3
1 BBBBB 86.57 8,879,065.02 234,986.25
2 AAAAA 1,631,276.63
3 CCCCC


ANY HELP WOULD BE GREATLY APPRECIATED.
--
Thanks
ETC