How to Make VLOOKUP Formula Dynamic

**pillr001** · 10-01-2018, 08:25 AM

Hi Guys,

How do I repeat the second part of this formula, like for example if the column does not contain ''Mid-Summer'', I want it to then check if it contains ''Wax-Man'' for example, then for it to VLookup the area for waxman or mid-summer depend on what what it contains.

This is the formula I'm using but it does not work. The second part is in red that I want it to repeat.

=IF(ISNUMBER(FIND("Mid-Summer",B1)),VLOOKUP(B7,A8:B8,2,0),ISNUMBER(FIND("Wax-Man",B1)),VLOOKUP(B4,A5:B5,2,0))

Thanks

**AliGW** · 10-01-2018, 08:36 AM

Welcome to the forum!

I have taken the liberty to update your thread title to fit in with our expectations here. Please use this as a guideline when composing thread titles in the future. Thanks.

**anupsubudhi** · 10-01-2018, 08:55 AM

hi pillr001,
can you provide a sample worksheet. that will make the things bit easier to explain.

regards
anup

**JeteMc** · 10-06-2018, 09:35 AM

If I understand correctly you need a second IF function as in:

Formula:

Please Login or Register  to view this content.

You didn't tell us what you wanted the formula to display if cell B1 contains neither "Mid-Summer" nor "Wax-Man", so as written the formula will return FALSE in that instance.
Let us know if you have any questions.