another vlookup help

[agron1974]

Hi again,

For the next stage, how do I set up the lookup formula in the first table to look for the item number in the 2nd table.

other

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3840;width:79pt" width="105"> </colgroup><tbody>
[TD="class: xl67, width: 64"]category[/TD]
[TD="class: xl67, width: 105"]hero[/TD]

[TD="align: right"]5[/TD]

</tbody>

[TABLE="width: 835"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]hero[/TD]
[TD]Item[/TD]
[TD]Title[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Aquaman[/TD]
[TD="align: right"]32724
[/TD]
[TD]Collectibles > Comics > Silver Age (1956-69) > Superhero > Aquaman[/TD]
[/TR]
</tbody>[/TABLE]

Thanks

 

[philwojo]

Are these tables on the same sheet, different sheets?

What cells do the tables utilize?
What do you want to display if it can't find a category during your search?

 

[Marcílio_Lobão]

agron1974, Good afternoon.

Your request is confusing.

When creating a message use the GO ADVANCED button and use the table creation buttons in the menu to help us understand the layout of your spreadsheet.

Please, explain your need a little better by giving us an example of research and how it would be the expected result.

I'm sure we can help you.

 

[agron1974]

I'm trying to match the category and the hero columns between the two tables. Once the two columns match up to give me the information in the item number column. Have the formula give me a N/A if nothing matches. They are on two separate tabs, both start at A1.

 

[Jotoya]

Hi agron1974,

I agree with Marcilio - your request is a bit confusing. But, here are my two cents: I ASSUME that you are attempting to enter a numerical value under the "Category" column say, in sheet1 and under the "hero" column the VLOOKUP function will return the hero you're looking for? Your lookup table being in sheet2. If so, the needed formula would be:

=VLOOKUP(A2,Sheet2!A1:D23,2,FALSE)

 

[sheetspread]

If you need a double lookup technique, try:

https://www.mrexcel.com/forum/excel-questions/585959-vlookup-multiple-conditions.html

 

[agron1974]

vlookupvlookupWhat's causing the confusion is this, I'm using =INDEX(info!A9:B233,MATCH(1,(info!A9:A233=X2)*(info!B9:B233=Y2),0),1). I'm thinking that a formula can offer me more help than this formula. What can I do?

Table 1
[TABLE="class: grid, width: 788"]
<colgroup><col span="3"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]*Action
[/TD]
[TD]*Category[/TD]
[TD]Product:UPC[/TD]
[TD]Title[/TD]
[TD][/TD]
[TD]year[/TD]
[TD]category[/TD]
[TD]hero
[/TD]
[/TR]
[TR]
[TD]Add
[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]
[/TD]
[TD]52 (2006-2007) #1C
[/TD]
[TD][/TD]
[TD="align: right"]2006[/TD]
[TD="align: right"]5[/TD]
[TD]other[/TD]
[/TR]
</tbody>[/TABLE]

Table 2
[TABLE="class: grid, width: 835, align: left"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Category
[/TD]
[TD]hero
[/TD]
[TD]Item[/TD]
[TD]Title[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="align: right"]3972[/TD]
[TD]Collectibles > Comics > Golden Age (1938-55) > Cartoon Character[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jotoya]

Maybe I'm the only one that is not getting it but, I'm not getting it. Your post is still very confusing agron1974. The problem/solution may seem very easy from your perspective but we, at least me, are not seeing it.

The way I am reading your last post is that you want the formula to be placed in the "*Category" column of Table 1 in which I assume you want it to read a value from Table 2 correct?? If so, the VLOOKUP should work fine.

Please reply if this will work. If not, please be very specific/thorough with what you're needing - bullet points maybe? The more guidance you provide to the forum viewers the better we can assist you.