Adding 'OR' into VLOOKUP Formula

**nastaiger** · 10-23-2019, 11:08 AM

I have VLOOKUP formulas created on an xlsx spreadsheet. You choose a selection from the dropdown and it poplulates a price. We have now added a 12 and 36 month pricing option for my pricing sheet. I need my formula to include 2 VLOOKUP options based on the selection of 12 or 36mths. My main formula is =IF($C$12=12,VLOOKUP(A33,U41:V45,2,FALSE),0). I need to add an OR =IF($C$12=36,VLOOKUP(A33,P42:Q50,2,FALSE),0), changing the 12 to 36mt in the beggining of the formula and pulling from a different set of numbers.

**Glenn Kennedy** · 10-23-2019, 11:16 AM

Try this:

=IF($C$12=12,VLOOKUP(A33,U41:V45,2,FALSE),IF($C$12=36,VLOOKUP(A33,P42:Q50,2,FALSE),""))

**modytrane** · 10-23-2019, 11:17 AM

=if($c$12=12,vlookup(a33,u41:v45,2,false),if($c$12=36,vlookup(a33,p42:q50,2,false),0)).

**nastaiger** · 10-23-2019, 11:42 AM

Thank you, that worked!. I 'm not sure were I was off, but I was.

**Glenn Kennedy** · 10-23-2019, 11:45 AM

You're welcome.

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

Adding 'OR' into VLOOKUP Formula

LinkBack

Thread Tools

Rate This Thread

Display

Adding 'OR' into VLOOKUP Formula

Re: Adding 'OR' into VLOOKUP Formula

Re: Adding 'OR' into VLOOKUP Formula

Re: Adding 'OR' into VLOOKUP Formula

Re: Adding 'OR' into VLOOKUP Formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Help with VLookUp Formula in adding values.

[SOLVED] Help adding something to my ifferror/Vlookup formula

[SOLVED] Vlookup formula is broken when adding a column

Adding a formula to VBA (IF, Vlookup etc)

[SOLVED] Adding conditions to a VLOOKUP formula

adding a vlookup formula with vba

Adding Prices on top of VLOOKUP formula

Bookmarks

Bookmarks

Posting Permissions