Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF and Vlookup?
Hi - is there a way to incorporate 1 more IF to this formula? I need to use
this formula but add which kind of currency to it so in cell B4 they choose which kind and then I need it to go look up specific to that currency in the other tab =IF(A17="","",VLOOKUP(A17,'PN Source Code'!$A$1:$F$29,3,FALSE)) B4 (drop down list from above) USD,EURO,YEN,GBP PN Source Code tab Product Name (which is what we are looking for from A17) USD is column C EURO is Column D YEN is Column E and GBP is Column F |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF and Vlookup?
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Heather" wrote in message ... Hi - is there a way to incorporate 1 more IF to this formula? I need to use this formula but add which kind of currency to it so in cell B4 they choose which kind and then I need it to go look up specific to that currency in the other tab =IF(A17="","",VLOOKUP(A17,'PN Source Code'!$A$1:$F$29,3,FALSE)) B4 (drop down list from above) USD,EURO,YEN,GBP PN Source Code tab Product Name (which is what we are looking for from A17) USD is column C EURO is Column D YEN is Column E and GBP is Column F |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF and Vlookup?
Thank you, works perfectly :
"Don Guillett" wrote: Answered using match row and match column within an index formula -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... If desired, send your file to my address below along with this msg and a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Heather" wrote in message ... Hi - is there a way to incorporate 1 more IF to this formula? I need to use this formula but add which kind of currency to it so in cell B4 they choose which kind and then I need it to go look up specific to that currency in the other tab =IF(A17="","",VLOOKUP(A17,'PN Source Code'!$A$1:$F$29,3,FALSE)) B4 (drop down list from above) USD,EURO,YEN,GBP PN Source Code tab Product Name (which is what we are looking for from A17) USD is column C EURO is Column D YEN is Column E and GBP is Column F |
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 |