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

VLookup
 

Vlookup("Text", RangeName, 3, 0)
Range name will be provided in cell A1

Try it with INDIRECT, viz.:
=Vlookup("Text", INDIRECT(A1), 3, 0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SHETTY" wrote in message
...
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

VLookup
 

Thanks
it works

Ramesh Shetty
"Max" wrote in message
...
Vlookup("Text", RangeName, 3, 0)
Range name will be provided in cell A1

Try it with INDIRECT, viz.:
=Vlookup("Text", INDIRECT(A1), 3, 0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SHETTY" wrote in message
...
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

VLookup
 

Welcome, thanks for posting back.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SHETTY" wrote in message ...
Thanks
it works