| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup worksheet, find value in any column
I am trying to look a worksheet with several colums, & trying to bring in a
value onto another worksheet if it is in any column. IE don't have to nominate the column the result should be in. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup worksheet, find value in any column
Assuming your data in A1:G100
H1: holds criteria =IF(COUNTIF(A1:G100,H1),H1,"NOT FOUND") "PeterH" wrote: I am trying to look a worksheet with several colums, & trying to bring in a value onto another worksheet if it is in any column. IE don't have to nominate the column the result should be in. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup worksheet, find value in any column
Thanks, I tried - if(countif('[Merged Supplier and
Products.xls]Sheet1'!$W$2:$AF$1012),BS3,"not found") not sure if you got what I ment, I am looking for a name in a cell on 1 worksheet, to see if it is in any column on another worksheet. "Teethless mama" wrote: Assuming your data in A1:G100 H1: holds criteria =IF(COUNTIF(A1:G100,H1),H1,"NOT FOUND") "PeterH" wrote: I am trying to look a worksheet with several colums, & trying to bring in a value onto another worksheet if it is in any column. IE don't have to nominate the column the result should be in. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup worksheet, find value in any column
how about this:
=if(countif('[Merged Supplier and Products.xls]Sheet1'!$W$2:$AF$1012,BS3),BS3,"not found") "PeterH" wrote: Thanks, I tried - if(countif('[Merged Supplier and Products.xls]Sheet1'!$W$2:$AF$1012),BS3,"not found") not sure if you got what I ment, I am looking for a name in a cell on 1 worksheet, to see if it is in any column on another worksheet. "Teethless mama" wrote: Assuming your data in A1:G100 H1: holds criteria =IF(COUNTIF(A1:G100,H1),H1,"NOT FOUND") "PeterH" wrote: I am trying to look a worksheet with several colums, & trying to bring in a value onto another worksheet if it is in any column. IE don't have to nominate the column the result should be in. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup worksheet, find value in any column
Countif isn't reliable for use on closed files.
Use Sumproduct instead. Biff "Teethless mama" wrote in message ... how about this: =if(countif('[Merged Supplier and Products.xls]Sheet1'!$W$2:$AF$1012,BS3),BS3,"not found") "PeterH" wrote: Thanks, I tried - if(countif('[Merged Supplier and Products.xls]Sheet1'!$W$2:$AF$1012),BS3,"not found") not sure if you got what I ment, I am looking for a name in a cell on 1 worksheet, to see if it is in any column on another worksheet. "Teethless mama" wrote: Assuming your data in A1:G100 H1: holds criteria =IF(COUNTIF(A1:G100,H1),H1,"NOT FOUND") "PeterH" wrote: I am trying to look a worksheet with several colums, & trying to bring in a value onto another worksheet if it is in any column. IE don't have to nominate the column the result should be in. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup worksheet, find value in any column
Thanks, you a bloody marvel! Works like a charm.
"Teethless mama" wrote: how about this: =if(countif('[Merged Supplier and Products.xls]Sheet1'!$W$2:$AF$1012,BS3),BS3,"not found") "PeterH" wrote: Thanks, I tried - if(countif('[Merged Supplier and Products.xls]Sheet1'!$W$2:$AF$1012),BS3,"not found") not sure if you got what I ment, I am looking for a name in a cell on 1 worksheet, to see if it is in any column on another worksheet. "Teethless mama" wrote: Assuming your data in A1:G100 H1: holds criteria =IF(COUNTIF(A1:G100,H1),H1,"NOT FOUND") "PeterH" wrote: I am trying to look a worksheet with several colums, & trying to bring in a value onto another worksheet if it is in any column. IE don't have to nominate the column the result should be in. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| To find Multiple values in column B for a unique value in column A | Excel Worksheet Functions | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
| FIND A TEXT IN A WORKSHEET NOT IN A COLUMN OR ROW BY FORMULA | Excel Discussion (Misc queries) | |||
| Find specific worksheet in another workbook and then applu Vlookup | Excel Worksheet Functions | |||
Hybrid Mode
