Return a Number to the Right of a Category Name...

[der_bq]

Okay, this is an odd one and I'm 100% sure there's an easy way to do this but I can't figure it out.

So I have the following query set up:

Item # Category Response
33 Name one of the 20 largest cities in the world: Mexico City

I have my data set up like this, going from left to right:

Item # / Category / Response / Response Total

Here's an example of the data:

1 Name a fruit where the skin is not eaten: Apple 1 Banana 17
I want to be able to enter in the Item #, Category Name, and Response and have my query return the response total which will be a number in the cell directly to the right of the response. I've tried DGET & VLOOKUP to no avail. I no the data isn't set up in the ideal format but it's what I've got to work with.

Does anyone have any suggestions?

 

[Dryver14]

i know this does not count but have you tried putting this in a table
andfiltering by response?

 

[der_bq]

I appreciate the response. It's kind of a weird thing that I'm trying to do. I'm doing a "Family Feud" type of game for some people at work so I don't want the entire table visible. I have the "DGET" function pulling the category for me, but I want to be able to type in someone's response into a cell and have a query use that response, along with the category to return the response amount which will always be the number to the right of the response, does that make sense? That's the only reason why I think a table would be less than ideal.

 

[Aladin Akyurek]

Try to post a scaled-down version of the table you have, some look up values of interest along with the desired result.