comment

[hitesh]

iam using a vlookup formula.

i have 2 sheet, in one sheet i have database in second sheet i type the
entry but in some entry i have to use comment, but this comment does not
reflect in the sheet 1 (original data base) only the entries reflect pls help.

 

[CLR]

I assume you are using the VLOOKUP formula .....which does not transfer
CommentBoxes or Formats, only cell values.....you could put the comments in
an adjacent cell and bring them in with an additional VLOOKUP formula.

hth
Vaya con Dios,
Chuck, CABGx3

 

[hitesh]

which additional vlookup formula i have to use. pls give me full details.

 

[CLR]

For example, assuming your Vlookup Table was in cells J1:K10, and in A1 you
put the value you wish to look up and in B1 your normal Vlookup formula,
something such as =VLOOKUP(A1,J1:K10,2,FALSE)

Assume you had Comment Boxes in cells K3:K5. Then, retype those comments
over in to cells L3:L5 respective. Then in cell C1 put the following formula.

=VLOOKUP(A1,J1:L10,3,FALSE)

And it will return the comment to go along with the value found by your
other VLOOKUP formula in B1

hth
Vaya con Dios,
Chuck, CABGx3