# Dual Formula Help

#### choccy

##### New Member
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.

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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)))

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.

Replies
0
Views
47
Replies
6
Views
313
Replies
3
Views
132
Replies
15
Views
848
Replies
1
Views
78

1,206,946
Messages
6,075,792
Members
446,158
Latest member
octagonalowl

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back