Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula -
Hi,
Legend: a1 b1 TX 8.25% MA 5% ------------- c1 d1 $100 MA $200 TX $300 EU -------------- How do I obtain a formula, perhaps vlookup, that if, column (D) matches with ledgen column (A), then take value column (c) time the percentage column (B), otherwise, N/A? Thanks Soth |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula -
Just how you said..something like
=C1*(vlookup(D1,$A$1:$B$3,0)) -- -John Please rate when your question is answered to help us and others know what is helpful. "Soth" wrote: Hi, Legend: a1 b1 TX 8.25% MA 5% ------------- c1 d1 $100 MA $200 TX $300 EU -------------- How do I obtain a formula, perhaps vlookup, that if, column (D) matches with ledgen column (A), then take value column (c) time the percentage column (B), otherwise, N/A? Thanks Soth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|