Please help...how to create a spreadsheet with these criteria?

C

Cpviv

Hi,

I need to setup a spreadsheet that has criteria go like this:

Cell A3 - Enter a key word. It will give me a list of the searched key words
(maybe comes from Data Validation List formula) for selection.

Cell B3 - It may shows two or more cells information for selection, after
cell A3 information select. The selection can come in drop-down list, or
appears in column B cells.

Cell C3 - It may shows two or more cells information for selection, after
cell B3 information select. The selection can come in drop-down list, or
appears in column C cells.

I know I need to use VLookUp and other formulas. But how should I go about
setting up this spreadsheet criteria?
 

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

VLookUp - Questions - Spreadsheet setup 3
Validation list with non blanks from different column 3
Drop Down List 7
SumIf with multiple Criteria 6
How can I use one cell to display another cell's value? 2
Create a separate list of duplicates 1
Selective Validation 4
Changing a cell value from another cell. 2

Top