Home

What formula do I use?

%3CLINGO-SUB%20id%3D%22lingo-sub-880886%22%20slang%3D%22en-US%22%3EWhat%20formula%20do%20I%20use%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880886%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20please%20help%3F%26nbsp%3B%20I'm%20new%20to%20formulas%20but%20have%20a%20basic%20understanding%20of%20excel.%26nbsp%3B%20I%20have%20this%20worksheet%20in%20excel%2010%20and%20I've%20copied%20and%20pasted%20values%20into%20one%20worksheet%20and%20the%20data%20is%20representing%202%20sets%20of%20info%20and%20I%20need%20to%20(search%2C%20find%20and%20match)%26nbsp%3B%20accts%20in%20one%20database%20and%20if%20those%20accts%20are%20found%20then%20tell%20me%20if%20they%20are%20reconciling%20items%20which%20is%20listed%20in%20a%20separate%20column.%26nbsp%3B%20Currently%20my%20worksheet%20with%20columns%20look%20like%20this%3A%20I%20need%20a%20formula%20to%20pull%20into%20col.%20D%20and%20E%20with%202%20separate%20findings!%3C%2FP%3E%3CP%3EA-acct%20number%20(database%201)%3C%2FP%3E%3CP%3EB-GL%3C%2FP%3E%3CP%3EC-Port%20code%3C%2FP%3E%3CP%3ED-where%20I%20want%20my%20return%20values%20to%20end%20up%3C%2FP%3E%3CP%3EE-where%20I%20want%20my%20return%20values%20to%20end%20up%20for%20part%202%20(is%20it%20a%20reconciling%20item)%3F%3C%2FP%3E%3CP%3EF-acct%20numbers%20(database%202)%3C%2FP%3E%3CP%3EG-Y%20or%20N%26nbsp%3B%20directly%20related%20to%20acct%20%23%20in%20F.%26nbsp%3B%20Y%20or%20N%20tells%20me%20if%20this%20acct%20is%20a%20recon%20item%3C%2FP%3E%3CP%3ESo%20columns%20A-C%20are%20pasted%20items%20from%20values%20I%20collected%20from%20one%20database%20and%20columns%20F-G%20items%20from%20a%20separate%20database%20and%20D%2FE%20are%20where%20I%20want%20final%20results%20of%20my%20formula%20to%20appear.%3C%2FP%3E%3CP%3EI%20need%20to%20take%20column%20A%20data%20which%20is%20acct%20numbers%20and%20see%20if%20they%20exist%20in%20column%20F%20and%20then%20find%20the%20match.%26nbsp%3B%20If%20theres%20a%20match%20then%20I%20want%20the%20acct%20%23%20to%20appear%20in%20col.%20D%2C%26nbsp%3B%20If%20not%2C%20then%20do%20nothing%20or%20leave%20blank.%26nbsp%3B%20(step%202)%26nbsp%3B%20if%20that%20acct%20number%20was%20found%20in%20col.%20F%20then%26nbsp%3B%20look%20to%20column%20G%20and%20place%20the%20value%20of%20G%20into%20column%20E.%26nbsp%3B%20The%20end%20result%20being%2C%20Do%20the%20acct%20numbers%20in%20col%20A%20exist%20in%20the%20second%20database%20(column%20F)%20and%20if%20they%20do%20then%26nbsp%3B%20then%20tell%20me%20if%20this%20acct%20is%20a%20reconciling%20item%20by%20putting%20a%20Y%20or%20N%20(info%20located%20in%20col.%20G).%26nbsp%3B%20Someone%20please%20help%20me%20simplify%20this!!%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3CP%3EMaddy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-880886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881189%22%20slang%3D%22en-US%22%3ERe%3A%20What%20formula%20do%20I%20use%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881189%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416844%22%20target%3D%22_blank%22%3E%40maddy4444%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20requirement%20seems%20simple%2C%20you%20can%20achieve%20it%20by%20using%20vlookup()%20function.%20You%20even%20do%20not%20need%26nbsp%3B%20to%20paste%20all%20data%20in%20one%20sheet%2C%20in%20excel%20you%20can%20easily%20apply%20formulas%20in%20multiple%20sheets%20%2F%20workbooks.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20sample%20file%20for%20your%20reference.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-881437%22%20slang%3D%22en-US%22%3ERe%3A%20What%20formula%20do%20I%20use%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881437%22%20slang%3D%22en-US%22%3EPlease%20simplify%20your%20requirement%20by%20attaching%20your%20sample%20file.%3C%2FLINGO-BODY%3E
maddy4444
Occasional Visitor

Can someone please help?  I'm new to formulas but have a basic understanding of excel.  I have this worksheet in excel 10 and I've copied and pasted values into one worksheet and the data is representing 2 sets of info and I need to (search, find and match)  accts in one database and if those accts are found then tell me if they are reconciling items which is listed in a separate column.  Currently my worksheet with columns look like this: I need a formula to pull into col. D and E with 2 separate findings!

A-acct number (database 1)

B-GL

C-Port code

D-where I want my return values to end up

E-where I want my return values to end up for part 2 (is it a reconciling item)?

F-acct numbers (database 2)

G-Y or N  directly related to acct # in F.  Y or N tells me if this acct is a recon item

So columns A-C are pasted items from values I collected from one database and columns F-G items from a separate database and D/E are where I want final results of my formula to appear.

I need to take column A data which is acct numbers and see if they exist in column F and then find the match.  If theres a match then I want the acct # to appear in col. D,  If not, then do nothing or leave blank.  (step 2)  if that acct number was found in col. F then  look to column G and place the value of G into column E.  The end result being, Do the acct numbers in col A exist in the second database (column F) and if they do then  then tell me if this acct is a reconciling item by putting a Y or N (info located in col. G).  Someone please help me simplify this!!  Thank you!

Maddy

 

 

 

2 Replies

Hi @maddy4444 

 

Your requirement seems simple, you can achieve it by using vlookup() function. You even do not need  to paste all data in one sheet, in excel you can easily apply formulas in multiple sheets / workbooks. 

 

I have attached a sample file for your reference.

Thanks

Tauqeer

 

Please simplify your requirement by attaching your sample file.
Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies