Excel-macro to auto populate value in cell [Closed]

Question

Excel-macro to auto populate value in cell [Closed]

Report

rahul79

Posts: 1
Registration date: Monday December 21, 2009
Status: Member
Last seen: December 22, 2009

- Dec 22, 2009 at 05:15 AM
Alex - May 3, 2010 at 12:11 PM

Hi,

I am new to Macros.I would really appreciate if someone can help me with the following problem.

I have created a validation in Column c and given the following values in the list
101857
83274
114711
80169

here every value has its own description

101857 - sales
81274 - Db2
104711 - Oracle
80169 - web

So if I choose 101857 in a cell in Column "c" then the corresponding column in D should be automatically filled in with value Sales.eg: If i choose 101857 in cell C3 then D3 should be auto populated with sales

I want this to be applied in all the cells in C and D columns.Please help!!!

Excel-macro to auto populate value in cell
Excel macro send email to address in cell ✓ - Forum - Excel
Excel macro to delete rows based on cell value - Forum - Excel
Excel macro to insert rows based on cell value - Forum - Excel
Excel macro to send email based on cell value - Forum - Programming
Excel macro insert picture based on cell value - Forum - Excel

1 reply

Ask a question

Alex · Answer 1 · 2010-05-03T12:11:11-0400

I believe you could do this with a simple VLOOKUP function.

Create a table with your list of description in two columns

A B
Column#1 Column#2
A1 101857 sales
A2 81274 Db2
A3 104711 Oracle
A4 80169 web

Now if you type in "101857" in cell (say D1) the you vlookup function in the corresponding cell (say E1) should read
=vlookup(D1,A1:B4,2,False)

Hope this helps!!!

Excel-macro to auto populate value in cell [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!