Issue with lookup tables

aleroguy · May 20th, 2002, 01:33 PM

I am trying to accomplish a task and am having a difficult time. Can anyone please help?

I have two columns of data that I need to search with. If both fields match, then I need Excel to output a specified value.

Ex: Column headings
Column A= Last name
Column B= First name

If the value in Column A is equal to Smith and the value in Column B is equal to Bill, I want excel to enter a value in Column C of "Yes."

Does anyone know how to accomplish this? Thank you for your help.

I have a list of various searches I would like to include. How do I include them all with one formula?

Ex: If Col A was Baker and Col B was Harry, then Col C is "yes" or Col A was Smith and Col B was Bill, then Col C is "No."

[ This Message was edited by: aleroguy on 2002-05-20 12:39 ]

Asala42 · May 20th, 2002, 01:36 PM

Hey,

Not sure if I follow completly, do you mean something like:

=IF(AND(A1="SMITH",B1="BILL"),"yes","no")

Adam

aleroguy · May 20th, 2002, 01:47 PM

Quote:

On 2002-05-20 12:36, Asala42 wrote:
Hey,

Not sure if I follow completly, do you mean something like:

=IF(AND(A1="SMITH",B1="BILL"),"yes","no")

Adam

With this formula I assume that Excel would look for Smith in column a and Bill in column b, if it found it it would print a yes, if not a no. This is what I am trying to accomplish, but I have about 400 various last name/ first name combinations. Can they all be included in the formula?

danam531 · May 20th, 2002, 02:18 PM

Not sure if you are familiar with vlookups...you could enter a column before first and last name. this column shoudl combine first and last name, for example, you add column A, cell A1 is =B1&", "&C1 Then somewhere else in the worksheet, you type in all your names. you could then enter in a vlookup =vlookup(A1,RANGE,1,FALSE) and it will return #N/A if the person is not on your list.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 01:33 PM	#1
aleroguy New Member Join Date: May 2002 Posts: 6	I am trying to accomplish a task and am having a difficult time. Can anyone please help? I have two columns of data that I need to search with. If both fields match, then I need Excel to output a specified value. Ex: Column headings Column A= Last name Column B= First name If the value in Column A is equal to Smith and the value in Column B is equal to Bill, I want excel to enter a value in Column C of "Yes." Does anyone know how to accomplish this? Thank you for your help. I have a list of various searches I would like to include. How do I include them all with one formula? Ex: If Col A was Baker and Col B was Harry, then Col C is "yes" or Col A was Smith and Col B was Bill, then Col C is "No." [ This Message was edited by: aleroguy on 2002-05-20 12:39 ]

May 20th, 2002, 01:36 PM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	Hey, Not sure if I follow completly, do you mean something like: =IF(AND(A1="SMITH",B1="BILL"),"yes","no") Adam

May 20th, 2002, 02:18 PM	#4
danam531 New Member Join Date: May 2002 Posts: 40	Not sure if you are familiar with vlookups...you could enter a column before first and last name. this column shoudl combine first and last name, for example, you add column A, cell A1 is =B1&", "&C1 Then somewhere else in the worksheet, you type in all your names. you could then enter in a vlookup =vlookup(A1,RANGE,1,FALSE) and it will return #N/A if the person is not on your list.