Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need information
Want to know if you can have more than one number in a formula for a column
index number. |
#2
|
|||
|
|||
Can you be a bit more specific? What exactly are you trying to achieve? What
is your input data? What are your formulas? What results did you expect? What did you get instead? But in general, the answer is YES -- Kind regards, Niek Otten Microsoft MVP - Excel "Angel aAlegria" wrote in message ... Want to know if you can have more than one number in a formula for a column index number. |
#3
|
|||
|
|||
=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE)) is the formula that
I am using, but i want to use columsn 2, 3, 4, 5 to bring up several prices. "Niek Otten" wrote: Can you be a bit more specific? What exactly are you trying to achieve? What is your input data? What are your formulas? What results did you expect? What did you get instead? But in general, the answer is YES -- Kind regards, Niek Otten Microsoft MVP - Excel "Angel aAlegria" wrote in message ... Want to know if you can have more than one number in a formula for a column index number. |
#4
|
|||
|
|||
Because you probably need the prices in separate columns, you need 4
formulas. You might take a look in HELP for the MATCH() function to avoid duplication of your somewhat complex mechanism to find the right row and use INDEX() to get the prices. -- Kind regards, Niek Otten Microsoft MVP - Excel "Angel aAlegria" wrote in message ... =IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE)) is the formula that I am using, but i want to use columsn 2, 3, 4, 5 to bring up several prices. "Niek Otten" wrote: Can you be a bit more specific? What exactly are you trying to achieve? What is your input data? What are your formulas? What results did you expect? What did you get instead? But in general, the answer is YES -- Kind regards, Niek Otten Microsoft MVP - Excel "Angel aAlegria" wrote in message ... Want to know if you can have more than one number in a formula for a column index number. |
#5
|
|||
|
|||
If you're talking about the ability to *copy* the formula across columns,
along a row, and *automatically increment* the column index number, just replace the "2" with "Column(B:B)". The "Column(B:B)" does *not* mean you're indexing Column B (although you very well might, just as a coincidence), it's used because it equates to "2", and will increment as it's copied along a row. =IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),Col umn(B:B),FALSE)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Angel aAlegria" wrote in message ... =IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE)) is the formula that I am using, but i want to use columsn 2, 3, 4, 5 to bring up several prices. "Niek Otten" wrote: Can you be a bit more specific? What exactly are you trying to achieve? What is your input data? What are your formulas? What results did you expect? What did you get instead? But in general, the answer is YES -- Kind regards, Niek Otten Microsoft MVP - Excel "Angel aAlegria" wrote in message ... Want to know if you can have more than one number in a formula for a column index number. |
#6
|
|||
|
|||
The colums I am gathering the information from are on a separate sheet. I
want 4 prices from a different sheet to appear in that cell. "RagDyeR" wrote: If you're talking about the ability to *copy* the formula across columns, along a row, and *automatically increment* the column index number, just replace the "2" with "Column(B:B)". The "Column(B:B)" does *not* mean you're indexing Column B (although you very well might, just as a coincidence), it's used because it equates to "2", and will increment as it's copied along a row. =IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),Col umn(B:B),FALSE)) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Angel aAlegria" wrote in message ... =IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE)) is the formula that I am using, but i want to use columsn 2, 3, 4, 5 to bring up several prices. "Niek Otten" wrote: Can you be a bit more specific? What exactly are you trying to achieve? What is your input data? What are your formulas? What results did you expect? What did you get instead? But in general, the answer is YES -- Kind regards, Niek Otten Microsoft MVP - Excel "Angel aAlegria" wrote in message ... Want to know if you can have more than one number in a formula for a column index number. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
Obtaining information from a database for a worksheet | Excel Discussion (Misc queries) | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |