Dual Formula Help

[choccy]

Hi,

So I Have a formula setup to pull data from another tab (sheet) and it works fine, however, I also want to be able to include formula to include pulling data from a second cell when a specific name is selected.

Currently my formula is this.....

=IF(B7="","",VLOOKUP(LEFT(B7,3),'Insurers Policy Numbers'!A:O,15,FALSE))

Now, column 16 holds data that I want to be used specifically only if I select a certain item from drop down (so for example, all come in as £0.00 at present) But this specific item should show up as £250.00

Is it possible to add something to allow me to say (if engineering is selected the amount will be as per column 16 ? )

Thank for any assistance.

 

[choccy]

Hi,

I solved it myself (yay)

=IF(F7="Engineering",IF(B6="","",VLOOKUP(LEFT(B6,3),'Insurers Policy Numbers'!A:P,16,FALSE)),IF(B6="","",VLOOKUP(LEFT(B6,3),'Insurers Policy Numbers'!A:O,15,FALSE)))

 

[Gerald Higgins]

Here's one way . . .

=IF(B7="","",VLOOKUP(LEFT(B7,3),'Insurers Policy Numbers'!A:O,15+(Z1="Engineering"),FALSE))

I'm not sure how you are determining that "Engineering" is selected, so I've assumed that value is entered into cell Z1.
Adapt as required.