Excel question - formula needed.?

Question

My documents are a bit more complicated, but the answer to the below simplified version would help greatly. Please see picture example at link:

http://i30.photobucket.com/albums/c326/Jennifer__B/ExcelExample.jpg

Thank you in advance!

Answer 1

Well there is a solution to your problem. Use the function. Vlookup.
In the column B in your sheet 2 where you need to generate the answers, enter this:
inB2 enter this exactly

=VLOOKUP(A2,Sheet1!$A$2:$B$6,
2,FALSE)

inB3 enter this

=VLOOKUP(A3,Sheet1!$A$2:$B$6,
2,FALSE)

in B4 enter this

=VLOOKUP(A4,Sheet1!$A$2:$B$6,
2,FALSE)

In the brackets after VLOOKUP; the first parameter is the reference cell or the common cell, the second parameter is the table and the third one is the column number of the table that you want as result.

So in your case for Sheet 2, in cell B2, we are looking up what is linked to A2 (Smith) in the table A2:B6 in Sheet 1. 2 means that we are looking in the second column. So we can create a larger matrix too, depending on the table size. FALSE says that we are looking for exact matching.

I hope you got the gist of it.

Answer 2

Here is formula for B column on the Sheet 2
=LOOKUP (A2,Sheet1!A:A,Sheet1!B:B)
=LOOKUP (A3,Sheet1!A:A,Sheet1!B:B)
=LOOKUP (A4,Sheet1!A:A,Sheet1!B:B)
....