comment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hitesh - 21 Dec 2006 07:31 GMT

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.

Reply to this Message

CLR - 21 Dec 2006 19:38 GMT

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

> 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.

Reply to this Message

hitesh - 22 Dec 2006 11:07 GMT

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

> I assume you are using the VLOOKUP formula .....which does not transfer
> CommentBoxes or Formats, only cell values.....you could put the comments in
[quoted text clipped - 9 lines]
> > 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.

Reply to this Message

CLR - 22 Dec 2006 13:10 GMT

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

> which additional vlookup formula i have to use. pls give me full details.
>
[quoted text clipped - 11 lines]
> > > 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.

Reply to this Message