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

HOW TO ADD VALUE THAT NOT APEAR IN TABLE

0

Hello, I'd like to know how i can add automaticly a value that not connected to the table.

There is a index that appears on the side of the table where I want to
peak data into the table autumaicly.
For example, numeric code = name



Answer
Discuss

Discussion

Please don't use ALL CAPS in the title.
don (rep: 1989) Apr 1, '19 at 5:04 am
Add to Discussion

Answers

0

I'm not entirely sure what you're wanting, is it a basic VLOOKUP() for column N?

Like this:

=VLOOKUP(M2,$R$2:$S$19,2,FALSE)
Discuss


Answer the Question

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