Have you tried putting your vlookups into an IF statement like -
if(vlookup(range,data,column,false)="#na","",vlook up(range,data,column,false
))
This will only give a number as an answer or a "". Then your formula to
pick up the value would be simple - like sum(4 cells) or max(4cells) or any
one of a number of calculations.

Chris

"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