VLookup

**jo15765** · 04-23-2013, 09:59 AM

How can I have 2 VLookups in one cell? For example I want to do this:

Please Login or Register  to view this content.

**JosephP** · 04-23-2013, 10:05 AM

and what's the problem?

**Fotis1991** · 04-23-2013, 10:07 AM

Which are the results?

**ragulduy** · 04-23-2013, 10:08 AM

Please Login or Register  to view this content.

You mean like that? That would give you the two numbers as a string.

**jo15765** · 04-23-2013, 10:13 AM

My return results are 0 when there is data in the cell I am trying to lookup.

**JosephP** · 04-23-2013, 10:15 AM

perhaps you could post a workbook?

your formulas assume the data is sorted in ascending order on column A

**Fotis1991** · 04-23-2013, 10:18 AM

Something else is the problem...If you use INDEX & MATCH, do you have the same problem? Can you upload a small sample workbook?

**jo15765** · 04-23-2013, 10:22 AM

Originally Posted by JosephP

perhaps you could post a workbook?

your formulas assume the data is sorted in ascending order on column A

I just sorted column A ascending and the results are coming in as needed. Thank you.

**Fotis1991** · 04-23-2013, 10:24 AM

Originally Posted by jo15765

I just sorted column A ascending and the results are coming in as needed. Thank you.

One of the reasons to use INDEX & MATCH...

**jo15765** · 04-23-2013, 10:29 AM

how would I combine an ISERROR syntax to this?

**Pepe Le Mokko** · 04-23-2013, 10:30 AM

Your XL version?

**jo15765** · 04-23-2013, 10:35 AM

2007 is the version I am running.

**JosephP** · 04-23-2013, 05:22 PM

=trim(iferror(Vlookup(D8, 'Sheet13'!$A$2:$N$66, 4, True),"") & " " & iferror(Vlookup(D8, 'Sheet13'!$A$2:$N$66, 6, True),""))

Re: VLookup