IF and VLOOKUP statement - not working

[mandiedwards0320]

Hello Everyone!

I am looking to create a formula to do the following..

If C14="THIS" then look in table on page 2 (columns B-F) for data in Cell E23(from page 1) and return pricing listed in column 3, but if Cell C14="THAT" then look in table on page 2 (columns B-F) for data in Cell E23 and return pricing in column 5.

I had a working formula using if statements and vlookups for this, but my computer crashed and I cannot recover the original worksheet and cannot remember how I came up with the formula.

Any help would be greatly appreciated.

Thanks!
Mandi

 

[Fluff]

Maybe
=INDEX(Sheet2!B2:F25,MATCH(E23,Sheet2!$B$2:$B$25,0),IF(C14="This",3,5))

 

[mandiedwards0320]

Maybe
=INDEX(Sheet2!B2:F25,MATCH(E23,Sheet2!$B$2:$B$25,0),IF(C14="This",3,5))

Unfortunately, this is not working. I know I originally created it using VLOOKUP and IF formulas.

 

[AhoyNC]

Maybe:
Change ranges to match your data.

=IF(C14="This",VLOOKUP($E$23,Sheet2!$B$1:$F$25,3,0),VLOOKUP($E$23,Sheet2!$B$1:$F$25,5,0))

<colgroup><col width="698"></colgroup><tbody>
</tbody>

 

[mandiedwards0320]

Maybe:
Change ranges to match your data.

=IF(C14="This",VLOOKUP($E$23,Sheet2!$B$1:$F$25,3,0),VLOOKUP($E$23,Sheet2!$B$1:$F$25,5,0))

<tbody>
</tbody>

No , this returns a "N/A" response.

 

[mandiedwards0320]

Hello Everyone!

I am looking to create a formula to do the following..

If C14="THIS" then look in table on page 2 (columns B-F) for data in Cell E23(from page 1) and return pricing listed in column 3, but if Cell C14="THAT" then look in table on page 2 (columns B-F) for data in Cell E23 and return pricing in column 5.

I had a working formula using if statements and vlookups for this, but my computer crashed and I cannot recover the original worksheet and cannot remember how I came up with the formula.

Any help would be greatly appreciated.

Thanks!
Mandi

This is the formula I use now-

=IF(ISNA(VLOOKUP(E23,'Price Sheet'!$B$2:$D$227,3,0))=TRUE,"$0.00,VLOOKUP(E23,'Price Sheet'!$B$2:$D$227,3))*H26

I just need to add the C14 component of if this or that and 2 additional columns to the array table on the price sheet page.

 

[AhoyNC]

It would help if you would post a small sample of your data.
Is the look up value in E23 in column B of sheet 2?

 

[Fluff]

Maybe
=IFERROR(INDEX('Price Sheet'!$B$2:$F$227,MATCH(E23,'Price Sheet'!$B$2:$B$227,0),IF(C14="This",3,5)),0)*H26