Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookUp
Dear Friends
I want to lookup value from defferent range of tables as per value in a cell Vlookup("Text", RangeName, 3, 0) Range name will be provided in cell A1 As and when value in A1 changes I want lookup formula to ge exact value from the desired table If I give reference to cell "A1" in the formula function returms #VALUE Please guide Ramesh Shetty |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookUp
On Jun 17, 10:26*am, "SHETTY" wrote:
Dear Friends I want to lookup value from defferent range of tables as per value in a cell Vlookup("Text", RangeName, 3, 0) Range name will be provided in cell A1 As and when value in A1 changes I want lookup formula to ge exact value from the desired table If I give reference to cell "A1" in the formula function returms #VALUE Please guide Ramesh Shetty You can use VLOOKUP("Text",INDIRECT(A1,1),2,0) where the reference is in the cell A1 in the format A1- style. if the reference is in R1C1 style change the Indirect part to indirect(A1,0) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLookUp
Thanks
It works Ramesh Shetty "Nayab" wrote in message ... On Jun 17, 10:26 am, "SHETTY" wrote: Dear Friends I want to lookup value from defferent range of tables as per value in a cell Vlookup("Text", RangeName, 3, 0) Range name will be provided in cell A1 As and when value in A1 changes I want lookup formula to ge exact value from the desired table If I give reference to cell "A1" in the formula function returms #VALUE Please guide Ramesh Shetty You can use VLOOKUP("Text",INDIRECT(A1,1),2,0) where the reference is in the cell A1 in the format A1- style. if the reference is in R1C1 style change the Indirect part to indirect(A1,0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
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 |