TRUE vlookup brings the wrong results
Hello to all, I wanted to make my full-of-vlookups workbook faster so I thought I would start using vlookups(TRUE) on a sorted table since I read that its faster that way. Problem is that, despite the fact that the lookup table is sorted and the fact that the lookup value does exist in said table, I can't get the vlookup(TRUE) to get the correct value. It does bring correct values on some lookups but not on all. Any ideas why might that be happening? thank you
Vlookup formula - partial text search
Hi, I am trying to use the Vlookup formula to search by Keywords in a cell and bring the value for category. I have the following example, on the first column I have the debits (long text with a lot of information). I want to search by the Keyword and bring the category to the second column. Someone can help? DEBIT CATEGORY KEY WORD Category PURCHASE AUTHORIZED ON 08/25 CHEVROLET KANSAS CITY KS J651695106198 CARD 1234 CHEVROLET CAR PURCHASE AUTHORIZED ON 08/23 ACE HARDWARE NEW YORK NY J51981981981981 CARD 1234 ACE HARDWARE UTILITIES PURCHASE AUTHORIZED ON 08/20 CHICK-FIL-A #1234 BOSTON MA Q1651651651981 CARD 1234 MCDONALD'S FAST FOOD PURCHASE AUTHORIZED ON 08/20 MCDONALD'S F1244 NEW YORK NY Q7161968168168 CARD 1234 CHICK-FIL-A FAST FOOD PURCHASE AUTHORIZED ON 08/20 WALMART F1244 NEW YORK NY Q7161968168168 CARD 1234 WALMART GROCERY PURCHASE AUTHORIZED ON 08/20 WALMART F1244 NEW YORK NY Q7161968168168 CARD 1234 WHOLE FOODS GROCERY PURCHASE AUTHORIZED ON 08/20 WHOLE FOODS F1244 NEW YORK NY Q7161968168168 CARD 1234
pull data based on dropdown list
Hey guys, 1 worksheet, 2 different tabs. On tab 1, I have a drop down status list for different projects (along with other project information in the row). When a specific status from the drop down list is chosen, I want that project (row of data) to populate automatically in a row in tab 2. I am struggling to populate only the list of a specific status in tab 2, and populate the rest of the line.URGENT Excel question HELP
3) Imagine I have 2 sets of similar data in Microsoft Excel, on 2 different tabs. How might you find the following: (Feeling industrious? Include a table with your work.) a) IDs found in tab 1 but not in tab 2. b) All data from tab 1 that matches IDs from tab 2. c) The total number of IDs that don’t match between the 2 tabs. Can you do it in a single formula?
Sum of Vlookup results
Looking for help with Vlookup Trying to use a formula and I think VLookup or Lookup is the solution. Want to find the total revenue for the office ORD from the table below. Result should be ($1795 + $1295 + $1150 + 310) = $4550. VLookup gives me just the first solution - $1795. So I think i'll need to add them up some way.
Running a IF(OR(AND fomula off a Vlookup
in cell E2, i have a Vlookup: =VLOOKUP($C:$C,'Vlookup Scott'!$C$2:$K$10,3,FALSE) and i need to run a If(OR(AND statement in cell Q2: =IF(OR(AND(E2="R",F2=8.25,P2<=1.4,P2>=1.2),AND(E2="R",F2=9.5,P2<=1.6,P2>=1.2),AND(E2="P",F2=8.25,P2<=1.5,P2>=1.3),AND(E2="P",F2=9.5,P2<=1.7,P2>=1.3)),"PASS","FAIL") it will only work when i have E2 as a regular text cell. is there a way to run Q2 with the vlookup in E2?
My whole Excel world is crumbling around me - interlinked workbooks using a lot of formulas and VBA
I have a 'set' of about a dozen spreadsheets through which I drive my family history projects. I have been having problems, for quite some time, with their opening as a 'set' and now, since the software updates which came through on 13th June, many of the interlinked formulas are just failing. Firstly when they are opened up, through a .bat file, they open up with the Internet source warning, despite the fact that all the workbooks, and all the associated xlams, are on one of my own hard drives and I created them all. I have added the directories to my safe sources list but they still come up with this message. Secondly, many of the formulas / workbook openings create messages, which say that the workbook has not been updated because the other spreadsheet was not recalculated before saving - such recalculation is not necessary in many cases. How can I remove this unnecessary check? Thirdly, some of the formulas are getting 'corrupted' every time I close the file, so that I have had to keep a text copy of the formulas in the worksheet, so that I can copy and paste the uncorrupted text of the formulas back in, every time I re-open the affected spreadsheets - this is a most annoying and time wasting activity - any ideas would be welcome, please. One thought I have had is that these 'corrupting' formulas are often quite complicated, often using quite a few nested IFs and/or VLOOKUPs [the VLOOKUPs often being ones that look across to another workbook]: would it be better if I tried to turn these formulas into my own VBA functions, maybe? With hopes for some ideas, please. I wish I could send someone the whole set of stuff, so that they could look for the flaws in my Excel use, but as a disabled pensioner I cannot afford to pay anyone, so I have to rely on Internet forums to try and get some help, please. Best regards Philip Bendigo, Victoria Australia
Vlookup to find multiple variations of a text string and return column
This is what I have so far: =VLOOKUP("*"&$H$2&"*", Datatable, COLUMN(A2), FALSE) $H$2 = Contains the text I'm searching for within Datatable When I run the formula, I only get the first instance of the text. However, I know there is more than one case that contains this text within the Datatable. Please help. I feel like I'm so close to getting this to work.
