× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
G
4
o
4
4
K
3
m
2
c
2
r
2
p
2
s
2
s
2
b
2
c
2
Home Q & A Board Science-Related Homework Help Mathematics Statistics and Probability
New Topic  
dionswife511 dionswife511
wrote...
Posts: 362
Rep: 0 0
6 years ago
The following table is used to lookup information on a specific product. There are several formulas in the table. How could I look at all the formulas that reside in this worksheet?
 
 
Q. 2

The following table is used to lookup information on a specific product. The Product ID is entered into the box and the information is returned in the green box. What would the lookup formula need to be in C8 to return the information for the Product named in B2.
 
 
Q. 3

The following table is used to lookup information on a specific product. The Product ID is entered into the box and the information is returned in the green box. What would the lookup formula need to be in C5 to return the information for the Product named in B2.
 
 
Q. 4

The following table is used to lookup information on a specific product. I chose to show the dependents of cell B2. How can I remove the arrows that are indicating the dependents?
 
 
Read 23 times
3 Replies

Related Topics

Replies
wrote...
#1
6 years ago
Ans. #1

Select Show Formulas in the Formula Auditing Group on the Formulas tab.

Ans. #2

65. The following table is used to lookup information on a specific product. The Product ID is entered into the box and the information is returned in the green box. What would the lookup formula need to be in C8 to return the information for the Product named in B2.


Ans. #3

=VLOOKUP(B2,A14:F44,2,FALSE)

Ans. #4
dionswife511 Author
wrote...
#2
6 years ago
Ready for finals now Monkey
wrote...
#3
6 years ago
Good luck my friend!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1185 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 2520
  
 365
  
 295
Your Opinion
Where do you get your textbooks?
Votes: 447
Previous poll results: Should Ph.D.'s be addressed as doctors?