I'm guessing you get #N/A if there is no match. Try using this

=if(isna(VLOOKUP()),0,vlookup())


"sweetsue516" wrote:


On worksheet 1 in A2 I have a cell value of American Advantage. In cell
A1 I need the value on worksheet to of the percent (0.43%).

I need a formula to do something like this. If worksheet 2 A1:A6 =
worksheet 1 A2, then let A1= worksheet b2. Then if the fund is not in list I
need worksheet A1 to equal 0.00%

This would be what worksheet 2 would look like.

AIM BASIC BALANCED $10,630.02 0.29%
AMERICAN ADVANTAGE SM CAP VAL $15,738.30 0.43%
AMERICAN BALANCED FUND R3 $12,906.04 0.35%
COLUMBIA ACORN $64,048.18 1.75%
EUROPACIFIC GROWTH $213,617.45 5.84%
Franklin Small-Mid Cap Growth $194,030.84 5.30%


Any suggestions. I used vlookup which works except for when the fund is not
in the list and I need a results of 0.00%