formula query

[Guest]

Hi all,

Got a quick question for ya's.

I am currently trying to hash out a formula along these lines:
=IF(F2="new","=vlookup(A2,p,2,0)",0)

I have tried adding the 'indirect' function but it still brings me no joy.

Any help would be greatly appreciated.

Regards,

Rikki

 

[Leo Heuser]

Hi Rikki

How about:

=IF(F2="new",vlookup(A2,p,2,0),0)

 

[Guest]

Cheers for that, it kinda works, but i need the A2 part of the formula to
move down with initial part of the formula eg. f2 and a2, f44 and a44 and so
forth.

 

[Leo Heuser]

Cheers for that, it kinda works, but i need the A2 part of the formula to
move down with initial part of the formula eg. f2 and a2, f44 and a44 and so
forth.

What do you mean by "move down"?
Apparently it has nothing to do with
copying the formula down.

Please clarify.

LeoH

 

[Guest]

I got it sussed now.

Thanks a million,

Riks

 

[den4673]

You have me curious...what was the solution? When I copied the formula
down the references changed with it. Also, doesn't the reference to p
in the vlookup have to be a range or range name?

 

[Guest]

yeah the references did change, its just i wasnt using the formula in the
correct corresponding row as i had begun to do the task manually. Also the
'p' reference is the range name. I just use single letters as its quicker.

 

[den4673]

Thanks, I should have figured that one out. That is a good idea to use
letters for range names, it makes it much easier. I think I will start
doing that as well.

Dennis