One way might be. Modify to suit
=INDEX(H4:H5,MATCH(1,H4:H5,-1))

"scott" wrote in message
...
Hi folks. I have 4 cells and each containe a v-lookup
formula. Only one of the 4 cells will ever contain a
number, the other 3 will contain #n/a since I used the
false statement in the v-lookup formula.

Now I would like to have a formula that would pick
whichever one of these 4 cells contain the number, and
exclude the other 3.

I have experimented with
=if(a20,a2) and this works fine, but how to continue the
formula to include B2, C2, and D2 is my question. Thanks