The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Excel 2007, looking up dynamically

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

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 2 years ago
Posts: 842


Here are instructions for posting images on the site

Posted 2 years ago
Posts: 8

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

Posted 2 years ago

Topic Closed

This topic has been closed to new replies.