Lookup/vlookup/hlookup

Resolved · Low Priority · Version Standard

Fri 7 Mar 2008, 15:41 Delegate Scott said...

Scott has attended:
Excel Advanced course
Access Introduction course

Lookup/vlookup/hlookup

How can I look up 2 criteria and return an answer - e.g find criteria in column A, find second criteria in column b and then return the answer from column c?

Sun 30 Mar 2008, 19:29 Trainer Mara said...

RE: lookup/vlookup/hlookup

Hello Scott,
I hope you enjoyed your Excel training session with us.

In response to your question, you cannot actually do a lookup based on two separate columns, and then returning the results from the third column. However, what I would suggest is that you concatenate columns A & B in your lookup and your results tables. Then you can perform your lookup based on the concatenation. To concatenate, use the following formula:

=CONCATENATE (text1,text2,...)

So for your example, this may look something like:
=CONCATENATE (A1," ",B1)

I added a <space> between A1 and B1, so that the concatenation doesn't merge the two words together. You can add any text or characters you would like by using quotation marks.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips