Formula to lookup cell value

G

Guest

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%
 
G

Guest

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

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

Guest

Barb,

It doesn't like the 0 in the middle of the , ,. I don't know if I am doing
something wrong or if I need a different formula. I don't understand this
one. Can you explain
 
G

Guest

=if(isna(VLOOKUP(B7,'MH AC'!A9:C25,3),0,VLOOKUP(B7,'MH AC'!A9:C25,3)

Is this correct? The cell and worksheet references should be the same in
both vlookups?
 
R

RagDyer

Is A9 to A25 sorted, ascending?

Since you're *not* using the 4th argument of Vlookup, the lookup table
*must* be sorted ascending for the return to be accurate.
 
G

Guest

I can get lookup and vlookup formulas to work great, but I run into problems
when the value I want looked up isn't listed.

When I value is not listed, I need it to display 0.00
 
G

Guest

Barb,

I posted a copy of that equation. Did you see it.

For some reason it is not working. Does my list need to be sorted ascending?
 
G

Guest

Barb,

I went back to double check the equation you gave me. I found the
problem...I missed a (

It works perfectly!!!
 
G

Guest

Try sorting column A in ascending order.



sweetsue516 said:
Barb,

I posted a copy of that equation. Did you see it.

For some reason it is not working. Does my list need to be sorted ascending?
Click to expand...
 

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

Similar Threads

Formula required for elapsed days for fund estimation 1
Find and replace a value within a formula 2
vlookup-cell range in formula changes when copied to another cell 2
How do I "PUSH" a cell value from one Worksheet to Another? 4
Show value of cell in formula bar instead of formula 2
Why can't I get the Conditional Sum Wizard to work? Here is my formula: 1
Function to put worksheet name in cell returns text, need number 5
Using a Cell Value to reference a Worksheet 3

Top