Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF vlookup return "value"
i want the cell to check 3 worksheets from another workbook and return S, FI
or PI depending on which sheet it is on, have the following but know its wrong, cannot fine tune. thanks anyone =IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,S,IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Income Securities'!$B$10:$D$413,FI, IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$413,PI,)))))) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF vlookup return "value"
Hi!
Yuck! Maybe something like this: =IF(COUNTIF('Path\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path \[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) Replace "Path" with: 'C:\Documents and Settings\Gillian Mason\My Documents\MDA Biff "Micayla Bergen" wrote in message ... i want the cell to check 3 worksheets from another workbook and return S, FI or PI depending on which sheet it is on, have the following but know its wrong, cannot fine tune. thanks anyone =IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,S,IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Income Securities'!$B$10:$D$413,FI, IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$413,PI,)))))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF vlookup return "value"
Thanks Biff. now it seems to work in that it doesnt ask for more info, but it
is blank when i know the value in A4 is on the first worksheet of the other doc. what say you =IF(COUNTIF('€˜C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('€˜C:\Doc uments and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('€˜C :\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) "Biff" wrote: Hi! Yuck! Maybe something like this: =IF(COUNTIF('Path\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path \[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) Replace "Path" with: 'C:\Documents and Settings\Gillian Mason\My Documents\MDA Biff "Micayla Bergen" wrote in message ... i want the cell to check 3 worksheets from another workbook and return S, FI or PI depending on which sheet it is on, have the following but know its wrong, cannot fine tune. thanks anyone =IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,S,IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Income Securities'!$B$10:$D$413,FI, IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$413,PI,)))))) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF vlookup return "value"
Hi!
What do you mean by: "it doesnt ask for more info" ? it is blank when i know the value in A4 What is blank? The result of the formula? It can't be. The only possible values that it can return a S, FI, PI or NONE (or an error if you have errors in any of those ranges). Biff "Micayla Bergen" wrote in message ... Thanks Biff. now it seems to work in that it doesnt ask for more info, but it is blank when i know the value in A4 is on the first worksheet of the other doc. what say you =IF(COUNTIF(''C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF(''C:\Docum ents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF(''C:\ Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) "Biff" wrote: Hi! Yuck! Maybe something like this: =IF(COUNTIF('Path\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path \[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) Replace "Path" with: 'C:\Documents and Settings\Gillian Mason\My Documents\MDA Biff "Micayla Bergen" wrote in message ... i want the cell to check 3 worksheets from another workbook and return S, FI or PI depending on which sheet it is on, have the following but know its wrong, cannot fine tune. thanks anyone =IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,S,IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Income Securities'!$B$10:$D$413,FI, IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$413,PI,)))))) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF vlookup return "value"
thats exactly right! it returns nothing, whereas it should return something.
what i mean by ask for more info is if the formula was incomplete or incorrect it usually has a dialogue box to that effect. "Biff" wrote: Hi! What do you mean by: "it doesnt ask for more info" ? it is blank when i know the value in A4 What is blank? The result of the formula? It can't be. The only possible values that it can return a S, FI, PI or NONE (or an error if you have errors in any of those ranges). Biff "Micayla Bergen" wrote in message ... Thanks Biff. now it seems to work in that it doesnt ask for more info, but it is blank when i know the value in A4 is on the first worksheet of the other doc. what say you =IF(COUNTIF(''C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF(''C:\Docum ents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF(''C:\ Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) "Biff" wrote: Hi! Yuck! Maybe something like this: =IF(COUNTIF('Path\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path \[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) Replace "Path" with: 'C:\Documents and Settings\Gillian Mason\My Documents\MDA Biff "Micayla Bergen" wrote in message ... i want the cell to check 3 worksheets from another workbook and return S, FI or PI depending on which sheet it is on, have the following but know its wrong, cannot fine tune. thanks anyone =IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,S,IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Income Securities'!$B$10:$D$413,FI, IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$413,PI,)))))) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF vlookup return "value"
sorry, i had my text in white. it is returning a value error.
"Biff" wrote: Hi! What do you mean by: "it doesnt ask for more info" ? it is blank when i know the value in A4 What is blank? The result of the formula? It can't be. The only possible values that it can return a S, FI, PI or NONE (or an error if you have errors in any of those ranges). Biff "Micayla Bergen" wrote in message ... Thanks Biff. now it seems to work in that it doesnt ask for more info, but it is blank when i know the value in A4 is on the first worksheet of the other doc. what say you =IF(COUNTIF(''C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF(''C:\Docum ents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF(''C:\ Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) "Biff" wrote: Hi! Yuck! Maybe something like this: =IF(COUNTIF('Path\[copy 2share recommendations.xls]Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path\[copy 2share recommendations.xls]Income securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path \[copy 2share recommendations.xls]Property & Infrastructure'!$B$10:$B$413,A4),"PI","None"))) Replace "Path" with: 'C:\Documents and Settings\Gillian Mason\My Documents\MDA Biff "Micayla Bergen" wrote in message ... i want the cell to check 3 worksheets from another workbook and return S, FI or PI depending on which sheet it is on, have the following but know its wrong, cannot fine tune. thanks anyone =IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Stocks'!$B$10:$D$413,S,IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Income Securities'!$B$10:$D$413,FI, IF(VLOOKUP(A4,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy 2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$413,PI,)))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup function return all values | Excel Worksheet Functions | |||
Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Excel Worksheet Functions | |||
Using a Vlookup to return values in a data list? | Excel Worksheet Functions | |||
Want VLookup to Return the row above | Excel Worksheet Functions | |||
Vlookup of an if statement return | Excel Worksheet Functions |