2 way lookup with rule.

[JapanDave]

I am trying to make a formula for looking up wall colors on a number of different houses. The rule is to Lookup certain colors (Green,Blue, Yellow) from a table and have them display in a different table and when a color is not specified have it show nothing. The two way lookup is to lookup the wall type and the house number.

This is my attempt at the code,obviously very wrong, so any help would be appreciated.

Please Login or Register  to view this content.

[HSV]

Try this one.

Please Login or Register  to view this content.

[JapanDave]

Hi Harry,

That code is giving me an error. could you possibly post it in an excel file? Non English excel does funny stuff to code.

Edit, I got your code to work, but it does not have the rule in it. I need it to only display the colors I specify.

Thanks.

[HSV]

Hi Dave,

I edit #2 for translate, but it went wrong (sorry).

Please Login or Register  to view this content.

[Cutter]

Here you go

[Cutter]

Sorry HSV - your green light wasn't on so I thought you were away.

[HSV]

Sorry HSV - your green light wasn't on so I thought you were away.

It’s okay Cutter, maybe I must change that, but I will go now for playing tennis.
success.

[Cutter]

Sorry Dave - try this

[JapanDave]

Thanks HSV.

Cutter, that last one did the trick. Slowly but surely I am starting to understand this lookup stuff. Your formula actually makes sense to me for the first time. (I have asked for other lookup formulas in the past and did not have a clue what that meant) I think some of this is actually sinking in.

Again thanks for the help. You and HSV now have rep points.

Cheers

Dave

[Cutter]

You're welcome Dave.

Thanks for the feedback and the "scales tap".

[JapanDave]

You are very , very welcome!