vlookup issue
 

In trying to perform the vlookup function bewtween two spreadsheets I have
encountered a problem: there is no response in selecting the sheet or columns
for the comparison table. I've trimed all the corresponding columns (just in
case) and yet I get no response when selecting the sheet (i.e., =vlookup(c5,
- this is as far as I can get). I've even tried to enter the formula
manually, but to no avail. HAve any suggestions?

vlookup issue
 

The normal construct for a VLOOKUP formula would be something like this

=VLOOKUP(C5,SHEET2!J1:K25,2,FALSE)

Does your formula resemble the sample?......if not, post your formula and
perhaps we can help.

Vaya con Dios,
Chuck, CABGx3



"Joe" wrote:

In trying to perform the vlookup function bewtween two spreadsheets I have
encountered a problem: there is no response in selecting the sheet or columns
for the comparison table. I've trimed all the corresponding columns (just in
case) and yet I get no response when selecting the sheet (i.e., =vlookup(c5,
- this is as far as I can get). I've even tried to enter the formula
manually, but to no avail. HAve any suggestions?