Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all!
What I am trying to do: In Sheet 1, column A, I have a list of account numbers. In Sheet 2, Column A, I have another list of account numbers. If an account in Sheet 1 column A, is also in Sheet 2, column A, then the account is budgeted; If an account in Sheet 1 column A is not in Sheet 2, column A, then the account is not budgeted. I'm not the cleverest with the formulas, and this is what I have tried and am not getting the best results: =IF(A2=(VLOOKUP(A2,Sheet2!$A$2:$B$1072,1,FALSE))," Budgeted","Acct Not Budgeted") It is working for accounts that are budgeted, but for accounts that aren't budgeted, I'm getting #N/A. I assume this has something to do with the VLookup. Any help as to where I'm going wrong would be greatly appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
a possible vlookup formula....help | Excel Discussion (Misc queries) | |||
help with vlookup formula | New Users to Excel | |||
VLookup Formula | Excel Discussion (Misc queries) | |||
Help with vlookup formula | Excel Worksheet Functions |