Ask Your Question
0

data from sheet2 name 1 column and ID second column used on sheet 1 [closed]

asked 2017-06-07 18:28:49 +0200

jamob gravatar image

im not sure if possible but i have a sheet to that has names on it with ids im wondering if there a way to get that data from sheet2 over to sheet 1 but only taking the name and id. basically im trying to get certain cells to auto fill with data from sheet 2. example i have name: jane smith and user ID: is blank on sheet 1 and on sheet 2 i have a list of names and smith, jane is in row A10 and her id is in B10 what i want to be able to do is when name is typed ID fills in with users ID from B10 and vice versa if user ID is given i would like the name to auto fill with name say Janes ID was 123456 so we put that in the name should auto fill with Smith, Jane. any ideas?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by jamob
close date 2017-06-13 17:15:07.323848

2 Answers

Sort by » oldest newest most voted
0

answered 2017-06-08 04:40:27 +0200

robleyd gravatar image

Is the data you are looking up sorted in col A? If not, change your formula to have the value zero for the last argument.

=VLOOKUP(A22,$Sheet2.$A$1:$D$8631,4,0)

Check the Help entry for VLOOKUP for more information.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
0

answered 2017-06-08 03:38:48 +0200

jamob gravatar image

i came up with this it is working but it keeps taking data from the row above the one its matching. and if it doesnt find exact name it gives you closest to it and i want it to come up NA if it findings nothing. =VLOOKUP(A22,$Sheet2.$A$1:$D$8631,4,1) it seems to be working just getting wrong row to come through. any ideas?

edit flag offensive delete link more

Comments

Look carefully at the fourth parameter. Not 1, but 0

JohnSUN gravatar imageJohnSUN ( 2017-06-08 06:17:17 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2017-06-07 18:28:49 +0200

Seen: 27 times

Last updated: Jun 08 '17