return

  1. G

    Key Word Search

    I am currently using a nested '=find(text,cell)' formula to categorise a list for example. If the term Doctor, Surgeon, Nurse, OT is in cell containing job title then the formula will return 'Medical'. This I have done by nesting separate find fictions for each key work with an if statement...
  2. S

    Multiple Lookup Values

    Hi, I have two tables similar to the following: 1. <tbody> A B C D E F G H Code op1 op2 op3 op4 op5 op6 op7 1 ABC123 XY none ZZ WR none none LUG 2 XYZ789 none none ZZ none LUG XY none </tbody> In this table each of the options has a drop down from a defined list. 2. <tbody> A B C...
  3. A

    Vlookup Only The First Lookup Value

    Hello, I think I have a fairly simple problem (but one I can't fix). Column A of sheet "Model" has hundreds of thousands of account numbers, many of which are duplicates. I need to vlookup based on those account numbers to return data from Column B of sheet "Cost", but I only want to return data...
  4. P

    Return a Suppler name from a text string

    Hi, thanks for looking? When I download some nominal data from the finance systeminto excel the supplier number (which is a mixture of letters and numbers) appearseither at the start, middle or the end of a text string including otherinformation. Therefore if I am wanting to do a vlookup against...
  5. T

    How to add a certain amount of years to a date?

    In cell A I have a date (e. 22-Jan-16). In cell B I have a number (ie. 10). How do I make cell C return the cell A date plus the number in cell B in years? So it would return 22-Jan-26.
  6. J

    Return Lookup based on range cell

    Hi all. I'm renting out construction tools and have my margin at different rates depending on the number of rental days. This is what my days-margin cells look like: <tbody> D E Days Margin 1 1.4 2 1.3 3-7 1.2 8-14 1.15 </tbody> If I have A3 titled "Number of Days", B3 shows the...
  7. F

    How do I get Excel to return a value based on the max value in a table?

    0 1 2 3 4 5 1 1 2 3 4 5 3 6 7 8 9 0 5 1 2 3 4 6 7 2 3 3 4 2 I have a table as such with rows and columns in bold. I know the max value within this table is 9. How can I get Excel to return "3" and "4"?
  8. B

    Search for multiple text within a cell and return text

    I'm trying to do multiple text searches in a cell and return text if true. If not true then I want the cell to be blank. For example Column A is PaymentNotFound12345 and I want the formula in column B to search for "PaymentNot" and return "PaymentNot". However I need to also search for other...
  9. P

    Conditional Copy, Paste to Another Sheet, Return to Start

    Greetings, I have a Workbook for tracking change orders. When an ECO is closed, I select any cell in the row and run the following to erase the data and clear the formatting on that row. Sub Clear_ECO() MSG1 = MsgBox("This action cannot be undone!" & vbCrLf & vbCrLf & "Selected Row is: " &...
  10. D

    efficient way to lookup and return multiple values?

    currently i i want to look up a unique security ID to another tab and return the inventories its in. the problem with obviously vlookup is that it would only return the first inventor result found.....what would be a way to return all the inventories the security ID is in? i suppose this can't...
  11. I

    Return to top of page icon always in users view on worksheet

    Hi, I have a long list in column E which is say 1000 + results down the page. I am in need of a Return to top of page code BUT a floating type if possible. I mean the Return to top icon which will hold the code must be in view on the worksheet whether i am on row 55, 239 or 850 then i can...
  12. D

    Nested if 3 conditions

    Hello, can you please help point me in the right direction on this formula. Basically it has 3 conditions depending on day count. If <60 it should return “80%” If >60 but under 180 it should return 75% And if over 180 it should return 65% I am trying this but it wont work...
  13. willow1985

    LEFT function of a certain word by a certain amount of characters

    Hello, I am looking for a formula that can find a certain work and return only 10 characters to the left of that word. For example OTHER INFORMATION.... FOR PO# 55222 FROM COMPANY Left of "From Company" I want it to return the PO# 55222 Any help would be appreciated Thank you! :) Carla
  14. Y

    Lookup between alphanumeric range?

    Hello, Probably being thick here and the obvious answer is alluding me but I need a formula to return a value based on where something is between a range of alphanumeric characters. At a basic level something like the below: <tbody> Start Location End Location Who A001 A100 MT A101 A200...
  15. S

    need tricky formula

    I'm looking for a non-array formula that will find the position in a list of the number closest to another number. In A1:A6, let's say I have 1;2;7; ;8;9 The closest number to 6 would be 7, so the formula would return 3 for the 3rd position. The closest number to 3 would be 2, so the formula...
  16. C

    Need an Subsitute Formula

    Have values in C21-G21 ranging from 0-3. if the value is a 0 or 1, return an 0;if the value is 2 or 3, return an 1. Thanks or any responses.
  17. G

    Return a true or false based on two cells

    Hi there. I have searched for the answer but I think maybe I'm not quite describing my aim correctly in order for the search to return what I need. Anyway I'm sure it's pretty easy for you guys. Here goes. I would like a function/formula for the following. If cell A1 is greater than the value...
  18. D

    Dividing to find an integer

    Hi, Is there a formula that would return an integer from a division calculation? For example: A1 will contain a varying non integer In A2 I would like to show the integer from dividing the value in A1 however, this division is limited by a set number. If A1 = 2.962 this number should then...
  19. willow1985

    Help with if formula with multiple conditions

    i am hoping someone can help me with an IF formula that has multiple conditions. I have tried a few different ways but still I cannot get it to work. What I require is if A2="0" then return a blank if L2 ="0" then return a blank If A2>L2 return "Late" If A2 is <=L2 then return "on time"...
  20. T

    Use A Tab Name As Part Of A VLOOKUP Formula

    Hi all, I am trying to use a tab name as part of a VLOOKUP formula however what I have so far returns #N/A VLOOKUP Formula =VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE) And in cell U5 I have the following: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) In this instance this...

Some videos you may like

This Week's Hot Topics

Top