Excel question

[kaiweiler]

I have a customer database filled with names, addresses, identification numbers, and identification type.
In Microsoft Excel 2007, is it possible to be in a different tab, type the customers name into a cell, and have the info of the specified related cells displayed?
Any help on doing this would be appreciated.

[c0ld]

yep, use vlookup/hlookup.

[Ac3Dunk]

Vlookup is your best choice, you can also try pivot table.

[lightshow]

You may want to also look into some VB macro code if you want to do more in depth searching across sheets

[kaiweiler]

Thanks everyone.
I seem to have run into an issue while using VLOOKUP.
Here is the situation:
The "Customers" Tab has the last names in column A, first names in column B, ID number in column C and ID Type in column D.

In another tab, I want to be able to type the customers full name and get the ID number inputted into the cell below.
So my formula looks something like this:
=VLOOKUP(H2,Customers!A3:R1000,13,FALSE)
*H2 being the field where you type the customers name, and 13 being the column C.

The issue is that I can only search either last or first name which is not specific enough. I need to be able to input "John A Smith" or "John Smith" and come out with the corresponding number in column C.

Is this possible?
Thank you very much for the help so far.