#### mandiedwards0320

##### New Member

- Joined
- Jun 18, 2013

- Messages
- 8

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