What is the proper formula to use for this?

[htchandler]

I'm trying to do a V lookup, the problem is that for each lookup value, there are three colums it will have to look at for a result. Only one of those three colums will have a result, the other two (for each lookup value) will be blank. I tried this:

=OR(VLOOKUP(E2,SIDPERS_ARNG!$A$2:$CZ$377,69,TRUE),VLOOKUP(E2,SIDPERS_ARNG!$A$2:$CZ$377,68,TRUE),VLOOKUP(E2,SIDPERS_ARNG!$A$2:$CZ$377,78,TRUE))

but it did not work. Any ideas?

Henry

 

[p45cal]

The colums it is refencing to CP,CQ, and CZ.

No it's not, you should be using 94,95 and 104 instead of 68,69 and 78

 

[htchandler]

I think there is something else wrong with the worksheet. I tried switching it to 94, 95, and 104 and it still didn't work. I even tried using =SIDPERS_ARNG!CQ282 and it just sat with that formula, never came back with an error or anyting. I ensured that the cell format was text.

 

[p45cal]

Try posting the workbook somewhere on the interweb…