vlookup

G

GlennUK

Well-known Member

Joined

Jul 8, 2002

Messages

11,871

Office Version

1. 2019
2. 2013

Platform

1. Windows

• May 24, 2011

• #2

Don't you mean that you want to lock the cell so that you can't type in it?

 

Upvote 0

P

Phill W

New Member

Joined

Aug 14, 2009

Messages

25

• May 24, 2011

• #3

naaa if cell is blank after vlookup, i may want to type a comment in cell, but do not want to loose formular in cell

 

Upvote 0

G

GlennUK

Well-known Member

Joined

Jul 8, 2002

Messages

11,871

Office Version

1. 2019
2. 2013

Platform

1. Windows

• May 24, 2011

• #4

So why not use the inbuilt Insert Comment functionality of Excel?

 

Upvote 0

P

Phill W

New Member

Joined

Aug 14, 2009

Messages

25

• May 24, 2011

• #5

i need to print this document each day

 

Upvote 0

S

Stu Dapples

Active Member

Joined

Jan 12, 2009

Messages

252

• May 24, 2011

• #6

Not really, if you type over a cell, its original contents are lost....

You can incorporate a sort of error handling statement into your Vlookup though:

=IF(Vlookup(value,range,offset,false)="","your comment",vlookup(value,range,offset,false))

Both the Vlookup statements are the same, if it returns a "" (blank) value, your text will be displayed instead....

I have used it with "", isna, iserror, its quite effective at removing grubby looking errors off your sheets!

 

Upvote 0

S

Stu Dapples

Active Member

Joined

Jan 12, 2009

Messages

252

• May 24, 2011

• #7

Or you could use a cell reference instead of the "your comment", that way you could type in to the target cell whatever you want displayed that day...

 

Upvote 0

P

Phill W

New Member

Joined

Aug 14, 2009

Messages

25

• May 24, 2011

• #8

can vlookup, look up 2 cells but search same table ?

 

Upvote 0

G

GlennUK

Well-known Member

Joined

Jul 8, 2002

Messages

11,871

Office Version

1. 2019
2. 2013

Platform

1. Windows

• May 24, 2011

• #9

Phill W said:

can vlookup, look up 2 cells but search same table ?

Click to expand...

Using what logic?

Is it going to be vlookup when cell1 = contents of column B and where cell2 = contents of column C

Or do you mean: vlookup using cell1, but if that fails then do vlookup using cell2

?

If you describe your questions more clearly, it would be a help.

 

Upvote 0