Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup help
Scenario:
Column A (Starting at A14) = Dates Column B (Starting at B14) = Stock Prices Column C (Starting at C14) = (This is where I need my Vlookup help) Column O (Starting at O9) = Dates (there are only 5 days of sale and purchase.) Column P (Starting at P9) = Shares purchased/sold I need help figuring out the Vlookup formula that will find my dates and multiply the information in column P by Column B to get the amount. Also since I don't want "N/A" to show up on the blank dates, if you could show me a nested if statement that would make the N/A's a zero...I would appreciate it. Please let me know if I need to explain more. =VLOOKUP(A14,O$9:P$13,2,FALSE) This is the Vlookup I had but it isn't multiply in the shares and the price... Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup help
Try the below formula
=IF(ISNA(VLOOKUP(A14,O$9:P$13,2,0)),"",VLOOKUP(A14 ,O$9:P$13,2,0)*B14) If this post helps click Yes --------------- Jacob Skaria "Confusicous" wrote: Scenario: Column A (Starting at A14) = Dates Column B (Starting at B14) = Stock Prices Column C (Starting at C14) = (This is where I need my Vlookup help) Column O (Starting at O9) = Dates (there are only 5 days of sale and purchase.) Column P (Starting at P9) = Shares purchased/sold I need help figuring out the Vlookup formula that will find my dates and multiply the information in column P by Column B to get the amount. Also since I don't want "N/A" to show up on the blank dates, if you could show me a nested if statement that would make the N/A's a zero...I would appreciate it. Please let me know if I need to explain more. =VLOOKUP(A14,O$9:P$13,2,FALSE) This is the Vlookup I had but it isn't multiply in the shares and the price... Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup help
That worked perfectly... Thanks for the help! It is much appreicated.
"Jacob Skaria" wrote: Try the below formula =IF(ISNA(VLOOKUP(A14,O$9:P$13,2,0)),"",VLOOKUP(A14 ,O$9:P$13,2,0)*B14) If this post helps click Yes --------------- Jacob Skaria "Confusicous" wrote: Scenario: Column A (Starting at A14) = Dates Column B (Starting at B14) = Stock Prices Column C (Starting at C14) = (This is where I need my Vlookup help) Column O (Starting at O9) = Dates (there are only 5 days of sale and purchase.) Column P (Starting at P9) = Shares purchased/sold I need help figuring out the Vlookup formula that will find my dates and multiply the information in column P by Column B to get the amount. Also since I don't want "N/A" to show up on the blank dates, if you could show me a nested if statement that would make the N/A's a zero...I would appreciate it. Please let me know if I need to explain more. =VLOOKUP(A14,O$9:P$13,2,FALSE) This is the Vlookup I had but it isn't multiply in the shares and the price... Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |