Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
I want to create a formula that performs a V-lookup from a range, then based
on that look-up, has an IF function to give me the correct data. Simply put, is it possible to nest two different functions within one cell? Also, how do I create formulas that get information from one spreadsheet to another without being row specific? I want to be able to pull the information from rows 1-200, into rows 1-X(based on a formula searching for specific values within the spreadsheet.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Take a look at INDIRECT in help. I think it will do what you want.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Chussong" wrote in message ... I want to create a formula that performs a V-lookup from a range, then based on that look-up, has an IF function to give me the correct data. Simply put, is it possible to nest two different functions within one cell? Also, how do I create formulas that get information from one spreadsheet to another without being row specific? I want to be able to pull the information from rows 1-200, into rows 1-X(based on a formula searching for specific values within the spreadsheet.) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
Hi
On the first question - yes you can nest multiple functions within one cell - see one of mine below: =IF($B364<"",(IF((VLOOKUP((VLOOKUP($B364,'One Line Data'!$A$3:$AG$982,7)),'Lookup Tables'!$D$47:$E$93,2))=(VLOOKUP(I$7,'Lookup Tables'!$F$47:$G$93,2)),1,"")),""). As for the second part of your query, I'm not quite sure what you want to do - sorry. Woody "Chussong" wrote: I want to create a formula that performs a V-lookup from a range, then based on that look-up, has an IF function to give me the correct data. Simply put, is it possible to nest two different functions within one cell? Also, how do I create formulas that get information from one spreadsheet to another without being row specific? I want to be able to pull the information from rows 1-200, into rows 1-X(based on a formula searching for specific values within the spreadsheet.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel considers my formulas as plain text | Excel Worksheet Functions | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |