Suggestions Please

[Brown]

Hello,
I have two pages, one page has ID number and Last name first name and other info. What I need to do on the second page is type in the ID number and have the personal information populate in the next three cells. Is this possible? What would you suggest is the least complicated way for this happen?
Thanks for the help, Happy Holidays and Merry Christmas
Brown

 

[alansidman]

IMO, the easiest way is to create two tables. Bring them into Power Query and merge the two (left outer join). If you need example, then post some data using XL2BB. No pictures please.

 

[Trebor76]

What I need to do on the second page is type in the ID number and have the personal information populate in the next three cells.

Can't you just use VLOOKUP? If you can post a sample of the workbook like Alan suggests it would be really useful to providing you with a solution.

 

[Michael M]

What was wrong with the suggestions offered on your other thread ??

 

[Brown]

1 -I have tried to down load the XL2BB add in and due to this being my work computer I do not have the admin rights to complete that download.

2 - I tried to use the information given on the other thread and I was unable to get it to function properly. I was hoping there might be another option that is why I posted this new thread.

I am sure there is something fairly simple I am misunderstanding, but not being well versed in VLOOKUP I am at a loss. I have looked at several tutorials and read a few things about it but something is not clicking.

apologies

Brown

 

[Michael M]

Did you look at mine ??
Keep in mind that I have used Sheet1 as an example sheet name only....If your is different change accordingly.

 

[Brown]

Did you look at mine ??
Keep in mind that I have used Sheet1 as an example sheet name only....If your is different change accordingly.

Yes, I have. I will go back and look at it again. I will try again in the morning with fresh eyes. I do appreciate the assistance.
Brown

 

[Brown]

This is my first sheet containing the personal info

Student ID	First Name	Last Name	Grade Level
1049384​	Bill	Smith	12​
1055550​	Jim	Black	12​
1062231​	Bob	Smalls	12​
1063728​	Susy	Que	12​
1065545​	Tom	Jerry	12​
1066206​	Sarah	Connor	12​

this is the second page of the workbook where i need the information to go when i type in the CCID

#	CCID	FIRST NAME	LAST NAME	Grade Level
1
2
3
4
5
6
7

i was able to get some help to download the add in.

Thanks again
Brown

 

[Trebor76]

So if the sheet containing the personal info is called Sheet1 and the details are across columns A to D you can use the following formulas in the second page in the cells mentioned (assumes the ID is in Col. B of the second sheet):

Cell C2: =VLOOKUP($B2,Sheet1!$A:$D,2,FALSE)
Cell D2: =VLOOKUP($B2,Sheet1!$A:$D,3,FALSE)
Cell E2: =VLOOKUP($B2,Sheet1!$A:$D,4,FALSE)

 

[Peter_SSs]

Duplicate to: VLOOKUP rookie question

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.