SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Excel 2007, looking up dynamically

(3 posts)
  • Started 1 year ago by niciana
  • Latest reply from Ursul
  • Topic Viewed 570 times

niciana
Posts: 1

What I am trying to do, if I can put it into words, is to lookup is the Product Detail, (Col C) as a drop down, by looking up the value in Col B and picking the colour (Colour_1-1...) from product table for the chosen Product Ref i.e. Product_1, Product_2.....).

I hadn't even got to the drop down part yet as I can't seem to find how to lookup the colour based on the column ref. (Column C).

Cant seem to figure aout how to send image or spreeadsheet to view... asking for Http ref????

Not doing very well for my first time

Posted 1 year ago
Top
 
moreeg
moreeg
Posts: 842

Hi

Here are instructions for posting images on the site

http://www.howtogeek.com/forum.....replies=16

Posted 1 year ago
Top
 
Ursul
Ursul
Posts: 8

So Niciana, any chance of seeing a copy of the spreadsheet?

Posted 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.