Formula - adding an IF Query onto vlookup query

Please see attached





Hi all, I have a rather a tricky one today..[for me anyway]... please see tab 'PSF', columns B and C

You will see a simple v-lookup table based on column D

The problem is this:
I need something to look at column F, and if the letters 'HGV' appear at all in this column then in overrides the values in columns B&C

So if 'HGV' appears in any way or form in column F then column B overrides the vlookup table and becomes the value "Maltby Substitute" and column C overrides the v-lookup table and becomes "Drax". I somehow need to add this in without damaging the existing formula.

Any ideas guys?

Thanks very much indeed in advance for any help,

M

Originally Posted by mra1984

...So if 'HGV' appears in any way or form in column F then column B overrides the vlookup table and becomes the value "Maltby Substitute" and column C overrides the v-lookup table and becomes "Drax". I somehow need to add this in without damaging the existing formula.

What do you mean by "without damaging the existing formulas" ?
If you want to get a change from the existing output, then, the "existing formulas" ARE going to get changed

HI,

Try for Col B

Formula:

Please Login or Register  to view this content.

and for Col C

Formula:

Please Login or Register  to view this content.

See the attachment

rajeshturaha

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Hi Fortis

Sorry, for that
It was not intentionally done.
I will keep that in mind in future.

Not my intention to punish members... I am Just trying to keep forum rules. This is my job here..

Pls be more carefull from now on!