How to autofill information from the next cell?

[ninjamalin]

I don't quite know how to ask this, so I will try my best to explain.

I have this information available.

test.png

And what I want to do is use this information further down in my excel-sheet. So whenever I plot in "Location 1" I want "Security" and "John Johnsson" to magically come automatically. Like this:

test.png

[Ursul]

Any chance of uploading a sample worksheet - it's easier to understand what you are wanting plus you will get more replies! Cheers

[benishiryo]

welcome to the forum, ninjamalin. try this in B14:
=VLOOKUP(A14,$A$1:$C$5,2,0)

in C14:
=VLOOKUP(A14,$A$1:$C$5,3,0)

copy down the formula. if you want it to appear automatically as you type in A24, convert the range to a Table. to do that, click on A14:C23 & press CTRL + T. uncheck the header if you really don't have one. they will create one for you anyway. if you really don't want it, go to the Design tab & uncheck header row.

you might have to change my commas to semi-colons for your region settings. and for future posting, it is always better to upload a sample excel file. To do that, Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
and to illustrate your example better, click on How To Get Quick & Good Answers