Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP, columns question / different way?
have an example of formula, as an array that finally works, but wonder if
there is a more dynamic way of find the column I am looking for? thanks where AP is the compared / start column in the old file, looking for data in column CI (had to count the columns by hand). Is there a more dynamic way to calculate the number of columns over, within the formula. would be will willing to calculate it outside the formula with referenced / worker cells, entering column letters in: From & To cells. sample working with is: =IF(ISNA(VLOOKUP(AQ327,[file.xls]sheet!$AP$1:$CI$3355,46,FALSE)),"",VLOOKUP(AQ327,[file.xls]sheet!$AP$1:$CI$3355,46,FALSE)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP, columns question / different way?
try
=Column(CI1)-Column(AO1) "nastech" wrote: have an example of formula, as an array that finally works, but wonder if there is a more dynamic way of find the column I am looking for? thanks where AP is the compared / start column in the old file, looking for data in column CI (had to count the columns by hand). Is there a more dynamic way to calculate the number of columns over, within the formula. would be will willing to calculate it outside the formula with referenced / worker cells, entering column letters in: From & To cells. sample working with is: =IF(ISNA(VLOOKUP(AQ327,[file.xls]sheet!$AP$1:$CI$3355,46,FALSE)),"",VLOOKUP(AQ327,[file.xls]sheet!$AP$1:$CI$3355,46,FALSE)) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP, columns question / different way?
Maybe you can use =index(match()) if you can match on unique headers.
Take a look at Debra Dalgleish's notes: http://www.contextures.com/xlFunctions03.html nastech wrote: have an example of formula, as an array that finally works, but wonder if there is a more dynamic way of find the column I am looking for? thanks where AP is the compared / start column in the old file, looking for data in column CI (had to count the columns by hand). Is there a more dynamic way to calculate the number of columns over, within the formula. would be will willing to calculate it outside the formula with referenced / worker cells, entering column letters in: From & To cells. sample working with is: =IF(ISNA(VLOOKUP(AQ327,[file.xls]sheet!$AP$1:$CI$3355,46,FALSE)),"",VLOOKUP(AQ327,[file.xls]sheet!$AP$1:$CI$3355,46,FALSE)) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Question... | Excel Worksheet Functions | |||
VLOOKUP question | Excel Worksheet Functions | |||
VLookUp Question | Excel Discussion (Misc queries) | |||
VLOOKUP Question. | Excel Discussion (Misc queries) | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |