If one cell matches a cell from a list....

[lars1565]

What I am trying to have happen:

I will have Student ID numbers in a column. Next to each ID number (the next column over) there will be additional info like "Paid" or "Not Paid".

I will have students enter their ID number is a cell and I want excel to put the additional piece of information ("Paid" or "Not paid") that matches their ID number in the cell next where they entered their number

I know I could do this with a very very long IF() but am hoping for something slicker.

Thanks in Advanced
LL

 

[FDibbins]

If you already have a list showing ID and paid/not paid,, then a simple vlookup will do what you want

 

[D3allamerican07]

Lars,

Depending on your workbook, you could use the formula:

=IF(A2="","",VLOOKUP(A2,Sheet1!A:B,2,0))

Have Sheet1 include a list of Student IDs and their additional info. Sheet2 should include Student ID in cell A1, and Info in B1. Put the formula in B2 and drag down. If you lock all cells in Column B, students can put their ID in each cell in column A and it will return whether they paid or not.

Let me know if this is what you were looking for.

Thanks,
Bill

 

[lars1565]

Yup, worked like a dream.
Thanks