Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Help

0

Trying to assign a value to  a name from a different table.

EX: If E1+E2=E3  i'm trying to assign E3 as a value to a name EX:

A1-Bill

A2-Tom

C1- Joe

When Bill is added in column A whatever row. I want that number  in E3 to be assigned to him in the next column?

I dont know if this made any sense but lets see

Thanks

excel
posted by: bdubs (rep: 2) on Thu Aug 12, 2021 at 11:11 am
Answer
Discuss

Discussion

Hi and welcome to the Forum.

I'm not clear what's in your table so please EDIT your question and use the Attach Files... button to upload a representative Excel file. Don't use Answer (which is reserved for sultions). Also...

Your question title "Help" may save you time but isn't helpful to other users or those who might have the knowledge to answer you. please also your question to change that subject to something like "Assigning a table value to a new entry" .

Finally, am I right to assume that you are not familiar with VBA (Excel's built-in programming language)?
John_Ru (rep: 6142) Aug 12, '21 at 12:12 pm
Hi John, Thanks for the repley. I was able to figure sit out using the following formula
Lookup-B2,'Table 1-1'::A1:E32,result-values)

However. As I drag the formula down to other rows the reference Table1-1 A1:A32 Moves down one row each time.  How to I keep it at A1:A32 through out?
bdubs (rep: 2) Aug 12, '21 at 1:02 pm
Replied as an Answer. It would still help others if you editted the  question subject as I requested (I can't do that)
John_Ru (rep: 6142) Aug 12, '21 at 1:31 pm
Add to Discussion

Answers

0
Selected Answer

If your formula refers to cells A1:A32 and you want to "fix" that for when you copy the formula (or use Fill Down), do this... 

Click in the text A1 then press function key  F4- that will make it read $A$1 which fixes both rows and columns for when you copy the formula. Do same for A32 or simply select the text A1:A32 and press F4.

You can also manually type the  dollar signs- the one before the column letter fixes the column, the one before the number fixes the row. You can use one or both, depending on your needs. 

posted by: John_Ru (rep: 6142) on Thu Aug 12, 2021 at 1:29 pm
Discuss

Discussion

Thank You. This Fixed It.
bdubs (rep: 2) Aug 12, '21 at 1:52 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login