Vlookup Help and if then statement?

[rentonhighlands]

Hello:
I want to write a vlookup statement but I also need to combine it with a if then statement I believe.

This is what I have
COL C has a list of codes. I am Vlookup against these codes.
Using the codes listed in COL C I am going to pull data from COL V (port)
Using the codes listed in COL C I am going to pull data from COL W (access)

The rules I want to follow are
Pull date from COL V and W
If COL V is blank then provide data from col T
If COL W is blank then provide data from col U
If COL V has a value and COL T is Orange then provide data from COL T
If COL W has a value and COL U is Orange then provide data from COL U

What are some formulas I can write to make this work?

Thanks

 

[SpillerBD]

"is Orange" as in the fill color? Can't do that from any formula function. If that is a conditional format, you'll have to perform the same calculation that the conditional formatting uses.

 

[rentonhighlands]

Yes orange is a fill color. However the fill color was manually done for the cell.

 

[rentonhighlands]

If a fill color can not be used in a formula can I use text color.

 

[SpillerBD]

If a fill color can not be used in a formula can I use text color.

No, Formats are not values and it's values that Excel is purposed for.

 

[NonStopLeo]

If a fill color can not be used in a formula can I use text color.

can you share your sheet here to have a look at it?
also tell, on what basis you have given orange color to cells?

 

[rentonhighlands]

sorry I can not share my sheet. The orange colors are hand colored cells by another person. Would something like this work? Can I nest a function inside VLOOKUP that says if COL T is greater or less then Col V then use the value from COL T? And to add If the value in COL U is greater or less then COL W then use value in COL U.

 

[SpillerBD]

You might use a "helper column" to provide the correct value between T & V. Then have your VLOOKUP just return that value.
While there is a lack of elegance in the solution, it is sometimes easier to follow, especially if that will be shared or inherited by someone else later.