Thread
:
Excel Formula Functions
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Excel Formula Functions
With a formula or a macro?
How do you get the info from the user.
Show us your efforts so far.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Steve K" wrote in message
...
Can someone give me the correct syntax for building a Lookup () formula.
The user will give me sheet name (i.e. Sheet1) and I want to use that
value
to build the formula. What is the correct way to use Sheet1 to build the
formula. Specifically, where do the quotes and double quotes go to build
teh
User Entered Value for teh Sheet and Range Name?
=Vlookup(23, User Entered Value Here for worksheet and Range Name, 3)
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett