Microsoft Microsoft office excel 2007 ac...

Column "A" of Sheet 2 has SERIAL NUMBERS. Column "B" of Sheet 2 has DESCRIPTIONS of the serial numbers.

I'm trying to show in C2 of Sheet 1, the DESCRIPTION of the SERIAL NUMBER I key in on C1 of Sheet 1.

For example:

Sheet 2:

Column A: A1=1, A2=2, A3=3 and so on...

Column B: B1=X, B2=Y, B3=Z and so on...Sheet1:

If I key in a SERIAL NUMBER (say 3) in C1, then C2 must show the DESCRIPTION of this SERIAL NUMBER, in this case Z.How do I do this?

Per the Excel Help files (an amazing resource) the syntax for VLOOKUP is as follows: VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Try:

=VLOOKUP(C1, Sheet2!$A$1:$B$100, 2, 0)

where Sheet2!$A$1:$B$100 should be changed to match the range of your actual data.

As written, this formula will return #N/A if the value in C1 is not found.

This formula will test for #N/A first and return a message if the value is not found:

=IF(ISNA(VLOOKUP(C1, Sheet2!$A$1:$B$100, 2, 0)), "Serial Number Not Found", VLOOKUP(C1, Sheet2!$A$1:$B$100, 2, 0))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

It worked as this: =VLOOKUP(D15,Table3[[#All],[UPC]:[DESCRIPTION]],2,FALSE)

But now I have to tell B7 to show [ADDRESS] if B6=(A2 on Sheet named 'CLIENT MATRIX').

How can I do this?

If I'm not mistaken, this will give you the same result: =VLOOKUP(D15, Table3[#All], 2, 0)

Since you are referencing the entire table with [#All], I don't think you need the column headers. (I'm just getting started with Tables in 2010, so feel free to correct me if I am wrong)

re: "

But now I have to tell B7 to show [ADDRESS] if B6=(A2 on Sheet named 'CLIENT MATRIX')."Is this a separate question? If so, please post it in it's own thread with a relevant subject line.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History