Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If formula help
Hello all,
here's what I'm trying to do: If part# in Column E is in column A, then pull the data from column B into column F, if no match, then leave blank or put no match. Here's what I tried doing: If (E:E=A:A, B:B:,"no match") but since column E and A do not have same amount of rows, the formula doesn't work. Would appreciate help with formula. Thank you, J |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If formula help
On Aug 5, 8:47*am, Juan wrote:
Hello all, here's what I'm trying to do: If part# *in Column E is in column A, then pull the data from column B into column F, if no match, then leave blank or put no match. Here's what I tried doing: If (E:E=A:A, B:B:,"no match") *but since column E and A do not have same amount of rows, the formula doesn't work. Would appreciate help with formula. Thank you, J Hi, Probably more a question for functions than the programming forum but you could use this formula, a bit more complicated than your original... =If(Iserror(match(E1,A:A,0)),"no match",Index(B:B,Match(E1,A:A,0),1)) So this assumes your putting your formula into F1, to look at cell E1, firstly it will see if E1 exists in column A if doesn't then it returns "no match", if it does it uses the index function to return the same row of column B that has the match in column A. Hopefully this makes sense, James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If formula help
On Mon, 4 Aug 2008 18:47:01 -0700, Juan
wrote: Hello all, here's what I'm trying to do: If part# in Column E is in column A, then pull the data from column B into column F, if no match, then leave blank or put no match. Here's what I tried doing: If (E:E=A:A, B:B:,"no match") but since column E and A do not have same amount of rows, the formula doesn't work. Would appreciate help with formula. Thank you, J =IF(ISNA(VLOOKUP(E?,A1:B1000,2,FALSE)),"",VLOOKUP( E?,A1:B1000,2,FALSE)) -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If formula help
Hello Dick and James,
both of you Thanks a lot. I tested both formula and seems to work fine. I really appreciated the help. Thanks again, J "Dick Kusleika" wrote: On Mon, 4 Aug 2008 18:47:01 -0700, Juan wrote: Hello all, here's what I'm trying to do: If part# in Column E is in column A, then pull the data from column B into column F, if no match, then leave blank or put no match. Here's what I tried doing: If (E:E=A:A, B:B:,"no match") but since column E and A do not have same amount of rows, the formula doesn't work. Would appreciate help with formula. Thank you, J =IF(ISNA(VLOOKUP(E?,A1:B1000,2,FALSE)),"",VLOOKUP( E?,A1:B1000,2,FALSE)) -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |