V-lookup

bthurgood@excite.com · Apr 6th, 2002, 08:49 PM

I need help with an assignment. I am trying to use v-lookup. the file that I am using is at http://www.business.utah.edu/~sonja/...am/prducts.xls, I know how to name the table, but it is just really stumping me. Can you please help.? I also need to know how to change the file so that the formulas show instead of the #'s . Thanks for the help

smozgur · Apr 6th, 2002, 09:25 PM

File link requires password.

I will try to answer when i see the file.

By the way: if you need VLookup basics

http://www.thewordexpert.com/excel.h...DreadedVlookup

regards

bthurgood@excite.com · Apr 6th, 2002, 09:34 PM

The password is spring, spring. I think, thanks again for the help.

smozgur · Apr 6th, 2002, 09:40 PM

spring
spring, spring
spring, spring.

none of them. And also need a user name.

Duane · Apr 7th, 2002, 08:51 AM

Hi,

To show formulas rather than the results of formulas, go on the menu to Tools|Options|View and then put a check in the Formulas box.

Keep in mind that this will change the layout of your spreadsheet somewhat, as columns will expand to display the entire formula in each cell.

_________________
Regards, Duane

[ This Message was edited by: Duane on 2002-04-07 07:52 ]

bthurgood@excite.com · Apr 7th, 2002, 08:59 AM

I just wanted to say thanks to both of you, the info was extremly helpful and the v lookup link answered my problem I really appriciate the help.

smozgur · Apr 7th, 2002, 02:58 PM

Nice to hear that.

Anytime.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2002, 08:49 PM	#1
bthurgood@excite.com New Member Join Date: Apr 2002 Posts: 3	I need help with an assignment. I am trying to use v-lookup. the file that I am using is at http://www.business.utah.edu/~sonja/...am/prducts.xls, I know how to name the table, but it is just really stumping me. Can you please help.? I also need to know how to change the file so that the formulas show instead of the #'s . Thanks for the help

Apr 6th, 2002, 09:25 PM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	File link requires password. I will try to answer when i see the file. By the way: if you need VLookup basics http://www.thewordexpert.com/excel.h...DreadedVlookup regards

Apr 6th, 2002, 09:34 PM	#3
bthurgood@excite.com New Member Join Date: Apr 2002 Posts: 3	The password is spring, spring. I think, thanks again for the help.

Apr 6th, 2002, 09:40 PM	#4
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	spring spring, spring spring, spring. none of them. And also need a user name.

Apr 7th, 2002, 08:51 AM	#5
Duane Board Regular Join Date: Mar 2002 Location: Toronto Posts: 173	Hi, To show formulas rather than the results of formulas, go on the menu to Tools\|Options\|View and then put a check in the Formulas box. Keep in mind that this will change the layout of your spreadsheet somewhat, as columns will expand to display the entire formula in each cell. _________________ Regards, Duane [ This Message was edited by: Duane on 2002-04-07 07:52 ]

Apr 7th, 2002, 08:59 AM	#6
bthurgood@excite.com New Member Join Date: Apr 2002 Posts: 3	I just wanted to say thanks to both of you, the info was extremly helpful and the v lookup link answered my problem I really appriciate the help.

Apr 7th, 2002, 02:58 PM	#7
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Nice to hear that. Anytime.