Formula not pulling the correct data based on a drop down list

**pleasesmile** · 06-27-2013, 10:17 AM

Good morning,

Some of my formulas seem to be working, but when I'm not getting the correct info when I choose 3 different items from a list.

why is the formula in F48 & I48 pulling numbers when c11= BL2000 U S1 (which has no data on the model table)?

why is the formula in F48 & I48 showing #N/A when C11=BL2000 4 S1 it should be pulling 0?

why is the formula in F48 & I48 showing #N/A when C11=BL2000 4 S2 it should be pulling data from the Model Table from column G?

Thank you,
ps

**XOR LX** · 06-27-2013, 10:32 AM

Hi,

You currently have the HLOOKUP set with no RANGE_LOOKUP, so it defaults to TRUE (approximate match). Try:

=IF($E$48="YES",HLOOKUP(Bag_Model,Model_Table,MATCH(LEFT(Liner,SEARCH("MIL",Liner)+2)&" WEIGHT",'Model Table'!$A$18:$A$166,0)+1,0),0)

Regards