Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
I am utilizing a vlookup function for retrieving data from multiple
worksheets. I had hoped that I could concatenate a range name and utilize that as the table array value in the Vlookup function, but I get a "#NA" value back. I did the concatenate function in another cell and it properly returned the name of the range name that defines my data range, but either utilizing the concatenate function in Excel or referencing the cell in the vlookup function produces an error. Can someone give me an idea. =CONCATENATE("SAPP",RIGHT(C1,2)) - this returns "SAPP24" - I would like this to return anything between SAPP24 to SAPP31. When I insert this value into the below Vlookup function: =VLOOKUP(A25,B24,6) and run the error analysis, the first value (A25) in the function returns the proper text, but I get the error when it tries to refer to cell B24 which is the "Concatentate" function listed above. Any help would be greatly appreciated. -- Thanks, SMH |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup
As long as "SAPP24" is in the same workbook:
=VLOOKUP(A25,INDIRECT(B24),6) -- Biff Microsoft Excel MVP "keydet1979" wrote in message ... I am utilizing a vlookup function for retrieving data from multiple worksheets. I had hoped that I could concatenate a range name and utilize that as the table array value in the Vlookup function, but I get a "#NA" value back. I did the concatenate function in another cell and it properly returned the name of the range name that defines my data range, but either utilizing the concatenate function in Excel or referencing the cell in the vlookup function produces an error. Can someone give me an idea. =CONCATENATE("SAPP",RIGHT(C1,2)) - this returns "SAPP24" - I would like this to return anything between SAPP24 to SAPP31. When I insert this value into the below Vlookup function: =VLOOKUP(A25,B24,6) and run the error analysis, the first value (A25) in the function returns the proper text, but I get the error when it tries to refer to cell B24 which is the "Concatentate" function listed above. Any help would be greatly appreciated. -- Thanks, SMH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |