VLookup & Match Formula yields N/A or wrong result- Unable to fix

[clhmms]

Hello most gracious gurus,

I have tried for about 2+ hours to fix my N/A error. This is what I have done:

• Changed all formats to general (except the item prices)
• Trimmed all cells
• Changed the text row/column headers to numbers
• Tried variations of the formula e.g. ending the formula with +1, false, and many other variations

Some of my attempts have yielded a price but never the correct price. I included a sample table for reference.

Does anyone have an idea? Any assistance would be greatly appreciated.
Thank you in advance for your time
Cassandra

PS- I am using Excel 2007


Below is a table of sample data. I didn't find where I could upload my xls.

		List$: Grp 1	List$: Grp 2	Base $: Grp 1	Base $: Grp 2
		ddd	aaa	ddd	ppp
				sss
CT4-3/8	W: 42 1/2" To 48", H: 57 3/4" <colgroup><col></colgroup><tbody> </tbody>	115	215	615	715
CT4.5-3/8	W: 48" to 53 1/2", H: 57 3/4" <colgroup><col width="197"></colgroup><tbody> </tbody>	135	235	635	735
CT5-3/8	W: 54" to 59 1/2", H: 57 3/4" <colgroup><col width="197"></colgroup><tbody> </tbody>	155	255	655	755
Select Model <colgroup><col width="127"></colgroup><tbody> </tbody>	CT4-3/8
Select Base Group <colgroup><col width="127"></colgroup><tbody> </tbody>	Base $: Grp 1
Result Price	=VLOOKUP(C12,B8:G10,MATCH(C13,D3:G3),1)

<tbody>
</tbody>

 

[Vidar]

Hi Cassandra

I took an educated guess on your row and column numbers on this one. Try it out:
=INDEX(D8:G10,MATCH(C13,B8:B10,0),MATCH(C14,D3:G3,0))

D8:D10 is your price range
C13 is the model lookup value, B8:B10 is model lookup range
C14 is the Base Grup lookup value, D3:G3 is the List/Base lookup range

Vidar

 

[clhmms]

Greetings Vidar,

Thank you for taking the time to respond to my post. I used your formula and it worked . Each time someone helps me with a post I do something nice for someone to pass along the kindness.

Thank you again!

Hi Cassandra

I took an educated guess on your row and column numbers on this one. Try it out:
=INDEX(D8:G10,MATCH(C13,B8:B10,0),MATCH(C14,D3:G3,0))

D8:D10 is your price range
C13 is the model lookup value, B8:B10 is model lookup range
C14 is the Base Grup lookup value, D3:G3 is the List/Base lookup range

Vidar

 

[Vidar]

You're most welcome Cassandra! So nice of you to doing something kind to others!

Vidar