VLOOKUP query

[thewiseguy]

Hi everyone,

I have a VLOOKUP which is working just fine. However, I need to add another function to this formula and I'm not sure if it can be done through a VLOOKUP.

Lets call the existing VLOOKUP, VLOOKUP-A.
I am going to add a VLOOKUP, called VLOOKUP-B.

I want my formula to look into cell A1 and if the value is "T" then I want to use VLOOKUP-A.
If the value in A1 is "W" then I want to use VLOOKUP-B.

I hope this is clear and any help is greatly appreciated.


-twg

 

[lenze]

Should be simple enough!

=IF(A1="T",VLOOKUP-A,VLOOKUP-B)

lenze

 

[thewiseguy]

Should be simple enough!

=IF(A1="T",VLOOKUP-A,VLOOKUP-B)

lenze

hi lenze...i dont think i worded my issue correctly. when i say "VLOOKUP-A" and VLOOKUP-B" i mean that those formulas already have variables in them.

Here is VLOOKUP-A:

=IF(ISERROR(VLOOKUP(B10,WHOLE,7,FALSE)),"",VLOOKUP(B10,WHOLE,7,FALSE))

VLOOKUP -B is going to be:

=IF(ISERROR(VLOOKUP(B10,WHOLE,8,FALSE)),"",VLOOKUP(B10,WHOLE,8,FALSE))

So when cell A1 = "T", i want my active cell to return the formula in VLOOKUP-A
when cell A1 = "W" I want my active cell to return the formula in VLOOKUP-B

 

[thewiseguy]

 

[lenze]

So:

=IF(A1="T",IF(ISERROR(VLOOKUP(B10,WHOLE,7,FALSE)),"",VLOOKUP(B10,WHOLE,7,FALSE)),IF(ISERROR(VLOOKUP(B10,WHOLE,8,FALSE)),"",VLOOKUP(B10,WHOLE,8,FALSE)))

lenze

 

[barry houdini]

Perhaps try....

=IF(ISNA(VLOOKUP(B10,WHOLE,8-(A1="T"),FALSE)),"",VLOOKUP(B10,WHOLE,8-(A1="T"),FALSE))

 

[thewiseguy]

So:

=IF(A1="T",IF(ISERROR(VLOOKUP(B10,WHOLE,7,FALSE)),"",VLOOKUP(B10,WHOLE,7,FALSE)),IF(ISERROR(VLOOKUP(B10,WHOLE,8,FALSE)),"",VLOOKUP(B10,WHOLE,8,FALSE)))

lenze

THX lenze, that worked perfectly!