I am trying to use a lookup in VBA where I need to search 2 columns.If one column has data,take that value or else look in the next column and take value.
My formula is saying ISNA Range1,8,0 then look in Range1,9,0 else Range1,8,0.
I am using the wrong formula because the lookup value exists in Range1 on both occasions.The formula works fine if the data was always in Col 8 but Col 9 will never be
read.
To get around this I have used a plain vanilla lookup then used If Then arguments to achieve the desired result.But very inefficient.
Could you guys please tell me how to get a lookup happening that has double scoops of chocolate chips with an assortment of nuts and caramel topping.
Much appreciated.
Budge
My formula is saying ISNA Range1,8,0 then look in Range1,9,0 else Range1,8,0.
I am using the wrong formula because the lookup value exists in Range1 on both occasions.The formula works fine if the data was always in Col 8 but Col 9 will never be
read.
To get around this I have used a plain vanilla lookup then used If Then arguments to achieve the desired result.But very inefficient.
Could you guys please tell me how to get a lookup happening that has double scoops of chocolate chips with an assortment of nuts and caramel topping.
Much appreciated.
Budge