Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula query
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 |
#2
|
|||
|
|||
Hi Rikki
How about: =IF(F2="new",vlookup(A2,p,2,0),0) -- Best Regards Leo Heuser Followup to newsgroup only please. "Chiccada" skrev i en meddelelse ... 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 |
#3
|
|||
|
|||
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" wrote: Hi Rikki How about: =IF(F2="new",vlookup(A2,p,2,0),0) -- Best Regards Leo Heuser Followup to newsgroup only please. "Chiccada" skrev i en meddelelse ... 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 |
#4
|
|||
|
|||
"Chiccada" skrev i en meddelelse
... 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" wrote: Hi Rikki How about: =IF(F2="new",vlookup(A2,p,2,0),0) -- Best Regards Leo Heuser Followup to newsgroup only please. "Chiccada" skrev i en meddelelse ... 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 |
#5
|
|||
|
|||
I got it sussed now.
Thanks a million, Riks "Chiccada" wrote: 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 |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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" wrote: 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? |
#8
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
formula query | Excel Discussion (Misc queries) |