Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to lookup cell value
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% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |