Need help writing a Formula

  • Thread starter Thread starter HandiMann
  • Start date Start date
H

HandiMann

Cell# 1 =Active cell, based on drop down list of 39 choices in Cell#
when choice is made, I then need to look up a table of the 39 with
possible values (in a range on another worksheet)



Thanks in advanc
 
Why not do a =VLOOKUP() on the contents of Cell #2 ?

Otherwise, in code, do a Find.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Filtered drop down list 2
Help needed 0
Filter a Drop List ? 1
Help Writing a SUM Formula 5
Excel Need Countifs Formula Help 0
Help with a range formula 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Back
Top