Searchable VLOOKUP?

Ohh I said the 'other' word for gender aha
The data is in a different worksheet (all data needed to be pulled are on this one), I wish to do the VLOOKUP on a worksheet on its own. I think input field is having the ability to type in the student id and the data appears, these things being 'dynamic', so that they change when a different id is inputted. Doing this for school and the teacher we have is bad at best so just going along the assignment criteria

This is hard to understand in the abstract although it sounds like you have a simple problem. Can you attach a file that shows how this data is set up, where is the input field, and an example of the result you want to see?

Also, you mentioned assignment criteria. We don't do your homework here, but can help move you in the right direction.

2J7HwS9.png
This is the data set, what I'm looking for is the ability (on a different sheet) for someone to be able to type in a student id and the following comes up; student name and gender.

Screen shots are almost useless. Please attach a file to get the best response.

Cell A1: this is where they type in the student ID

This formula will give the forename

Formula:

Please Login or Register  to view this content.

Surname

Formula:

Please Login or Register  to view this content.

Gender

Formula:

Please Login or Register  to view this content.

Originally Posted by FDibbins

Did you try my suggestion from post #5? (obviously adjust the ranges etc)

No sorry I found it a little difficult to understand

Anyways thanks for all the help so far, here is the doc http://www.filedropper.com/yeah_2
I managed to do the little amount of VB coding thats in there but I am really struggling to get this VLOOKUP thing done
Thanks

To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Here are step-by-step instructions with screen shots

Originally Posted by 6StringJazzer

To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
3. In the pop-up, click Add then Select to select a file from your local drive
4. Click the Upload button to upload the file
5. Click Done to attach it.

It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.

Here are step-by-step instructions with screen shots

Unfortunately I go to click to on the upload icon and the pop up to upload never loads, its just blank

Yeah, we've been having some trouble with that on and off. After clicking Go Advanced, scroll down and you should see a button "Manage Attachments". Try that. The window will look different than my instructions but it should be self-explanatory.

That should do it!