V-lookup

[bthurgood@excite.com]

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/act1420/excelexam/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]

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.htm#TheDreadedVlookup

regards

 

[bthurgood@excite.com]

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

 

[smozgur]

spring
spring, spring
spring, spring.

none of them. And also need a user name.

 

[Duane]

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]

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]

Nice to hear that.

Anytime.