look-ups from one sheet to another

[Pteridium]

hello, would be very grateful for some help.

I have two spreadsheets, one with data regarding students' attendance at events, and 2nd sheet with general data about students (including supervisor details).
I need to get supervisor details (single column) into the first spreadsheet.
I think this means doing a look-up, but not sure (a) if that's right, or (b) how do to it.
could someone point me in direction of a fool-proof tutorial in non-tech speak, or explain it.

thank-you very much in advance.

[NBVC]

Have a look at VLOOKUP in Excel's help files.

[mhuston]

hello, would be very grateful for some help.

I have two spreadsheets, one with data regarding students' attendance at events, and 2nd sheet with general data about students (including supervisor details).
I need to get supervisor details (single column) into the first spreadsheet.
I think this means doing a look-up, but not sure (a) if that's right, or (b) how do to it.
could someone point me in direction of a fool-proof tutorial in non-tech speak, or explain it.

thank-you very much in advance.

You need to have a common value in each sheet:
Sheet 1
name supv
Sheet 2
supv supvdetails otherstuff

You are looking up Sheet 1's column b as the lookup_value (the common value in each sheet), all cells with data in Sheet 2 as the table_array, and 2 as the col_index (the number of columns in Sheet 2 that contains the data you want to pull into Sheet 1).

[Pteridium]

well, I tried, but no luck. Thanks for trying tho guys.

[NBVC]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[Pteridium]

ok, so here is a dummy worksheet that illustrates what I need to do. sheet 1, I have highlighted the column where I want to 'import' information. Sheet 2, I have highlighted the information that I want to import. The common factor between the two sheets is student surname.

Thanks.

[NBVC]

Ok since your lookup column is to the right of the results column, then the standard Vlookup as we described won't work..

You can try:

=INDEX('second sheet'!J:J,MATCH(B2,'second sheet'!$L:$L,0))