Can cells be formatted so that if A2 says "Joan", G2 says "$25"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a spreadsheet that when I enter or select certain
information, other column and line info needs to change (always the same
info) too. For example: I enter a name "joan" in A2. B2 needs to have a
certain rate for Joan, and G2 has a certain other piece of info ALL
PERTAINING TO JOAN. This is a spreadsheet that I am creating.

What is that called and how do I set it up?
 
Have a look in Help at VLOOKUP
Come back for more help if needed
best wishes
 
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

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
How to keep a set range in a Search function 2
Extracting data 1
How do I average cells that contain #DIV/01? 2
Format cell based on date 1
Conditional Format for Blank Cells 5
Copying formulas across columns 2
VLookup that returns two separate cells instead of only one 3

Back
Top