How to have Excel generate values based on my data

**Jmenace** · 07-07-2011, 10:24 PM

Hello,
I'm trying to do the following:
In column A I enter data, in this case the number 4,5,6, or 7. There are values associated with each number that I would like to have excel populate in column B.

Example.
When I enter a 4 in column A I would like excel to automatically enter 100 in column B. When I enter a 5 in column A I would like excel to automatically enter 200 in column B.
etc.

Can someone walk me through this or link me somewhere where this is shown? I feel like it can be done fairly easily I'm just not even sure what to search for.

Thanks, much appreciated.

**stanleydgromjr** · 07-07-2011, 11:10 PM

Jmenace,

You could use a LOOKUP formula.

Copy this formula into cell B1:
=IF(ISNA(LOOKUP(A1,{4,5,6,7},{100,200,300,400})),"",LOOKUP(A1,{4,5,6,7},{100,200,300,400}))

If you enter into cell A1, you will get in B1:
A1 B1
1 blank
4 100
5 200

If you did not want to use a formula, you could use the Worksheet_Change Event that would fill into column B the correct value.

Can we see your workbook?

To attach your workbook, click on the New Post button, then scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

How to have Excel generate values based on my data

LinkBack

Thread Tools

Rate This Thread

Display

How to have Excel generate values based on my data

Re: How to have Excel generate values based on my data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions