Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula within a formula
We are attempting to usa a formula within a formula. Our first formula is a
lookup between two tabs and it returns a "Y" or "N" in tab one for our research purpose. A "Y" if it found the same name in the tab 2, and an "N" if it did not find the name in the 2nd tab. Let's say that it gives us the desired result in column G. Is it possible to expand on the existing formula? If we get a "Y", meaning it found a name match, we want it to look at the date associated with the name in the 2nd tab and put it in column H, directly next to the "Y". The dates are in column B, 2nd tab, and here is what we've encountered. The formula we have used will return a "Y" or "N" as stated earlier, and it will look at the date in column B, but it starts at the very top and just goes right down the column, in order. So, John Doe might be found in row 4,356 in the 2nd tab, and instead of looking at the date in column B on row 4,356 and returning that in column H in our first tab, it will just continue with where it left off from the top of column B in sequential order. Does that make sense? Just trying to make sure this easily understood, please forgive my redundancy. Here is a copy of the formula we currently have: =IF(ISNA(MATCH(F2,'Payee Changes List'!H:H,0)),"no",'Payee Changes List'!B:B). Obviously our 2nd tab is titled "Payee Changes List", the names are in column H and the dates in column B. Is it possible to do what we are attempting? Thanks for any and all help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula within a formula
=IF(ISNA(MATCH(F2,'Payee Changes List'!H:H,0)),"",INDEX('Payee Changes List'!B:B,MATCH(F2,'PAyee
Changes List'!H:H,0))) HTH, Bernie MS Excel MVP "CSmith" wrote in message ... We are attempting to usa a formula within a formula. Our first formula is a lookup between two tabs and it returns a "Y" or "N" in tab one for our research purpose. A "Y" if it found the same name in the tab 2, and an "N" if it did not find the name in the 2nd tab. Let's say that it gives us the desired result in column G. Is it possible to expand on the existing formula? If we get a "Y", meaning it found a name match, we want it to look at the date associated with the name in the 2nd tab and put it in column H, directly next to the "Y". The dates are in column B, 2nd tab, and here is what we've encountered. The formula we have used will return a "Y" or "N" as stated earlier, and it will look at the date in column B, but it starts at the very top and just goes right down the column, in order. So, John Doe might be found in row 4,356 in the 2nd tab, and instead of looking at the date in column B on row 4,356 and returning that in column H in our first tab, it will just continue with where it left off from the top of column B in sequential order. Does that make sense? Just trying to make sure this easily understood, please forgive my redundancy. Here is a copy of the formula we currently have: =IF(ISNA(MATCH(F2,'Payee Changes List'!H:H,0)),"no",'Payee Changes List'!B:B). Obviously our 2nd tab is titled "Payee Changes List", the names are in column H and the dates in column B. Is it possible to do what we are attempting? Thanks for any and all help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |