IF + VLOOKUP: easier method?

Hi all,

I currently have a spreadsheet where I have a lookup of client name to another tab. However, if the client has certain name, I have it vlooking up to a sub-client in another tab. However, it looks like I'm entering too many conditions because I am now getting error message saying "This formula uses more levels of nesting than you can use in the current file format". Is there a way to shorten this formula?


Here's how the formula currently looks:
=IF(D27="STAR AGENCY",VLOOKUP(G27,Vlookup!$D:$F,2,FALSE),IF(D27="CIRCLE AGENCY",VLOOKUP(G27,Vlookup!$D:$F,2,FALSE),IF(D27="SQUARE AGENCY",VLOOKUP(G27,Vlookup!D:F,2,FALSE),IF(D27="DIAMOND AGENCY",VLOOKUP(G27,Vlookup!D:F,2,FALSE),IF(D27="TRIANGLE AGENCY",VLOOKUP(G27,Vlookup!D:F,2,FALSE),IF(D27="OVAL AGENCY",VLOOKUP(G27,Vlookup!$D:$F,2,FALSE),IF(D27="BLUE AGENCY",VLOOKUP(G27,Vlookup!$D:$F,2,FALSE),VLOOKUP(D27,Vlookup!$A:$B,2,FALSE))))))))

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Once a formula even "looks" like it's getting long you should consider using a lookup table.

I can't quite see that image, hang let me get me microscope!

Here's one way...

=IF(OR(D27={"STAR AGENCY","CIRCLE AGENCY","SQUARE AGENCY","DIAMOND AGENCY","TRIANGLE AGENCY","OVAL AGENCY","BLUE AGENCY"}),VLOOKUP(G27,Vlookup!$D:$F,2,0),VLOOKUP(D27,Vlookup!$A:$B,2,0))

You're welcome. Thanks for the feedback!