Need data transferred between worksheets

[Fwood]

Hello-

Excel novice here. Given 2 sets of data in worksheet A (a diagnosis column and a diagnosis code column) given just the diagnosis column in worksheet B is there a formula to get the diagnosis code column to populate in worksheet B?

Thanks in advance.

 

[mumps]

Assuming you have headers in row 1 of both sheets, place this formula in cell B2 of sheet B and copy it down: =VLOOKUP(A2,A!A2:B8,2,0)
Change the range to suit your needs.

 

[Fwood]

Thank you for the response. The formula may need to be tweaked based on information I forgot to include in my initial post. The code that is needed to be captured is in column B of sheet 1. The blank column it needs to populate in is column F of sheet 2. The diagnosis column of sheet 1 is column C of sheet 1 and is column B of sheet 2. Given that how should the lookup be written? Thanks again for your help.

 

[mumps]

Place this formula in F2 of Sheet2 and copy down: =INDEX(Sheet1!B2:B7,MATCH(B2,Sheet1!C2:C7))