look for value

I'm wanting to return a value that corresponds to another value that is closest to a target value that I determine. For example, in cell H4, I input the number 6 which returns 113 in cell J4. This currently works as 6 is closest to 5 in column B (mins) and the value 113 in column C (var1) is...

I have a spreadsheet that is formatted a way to make simpler functions not possible (as far as I know). I don't want to have to reformat it nor do I want to use macros. The ranges are dynamic so I am unable to just hardcode the locations of the information I want. My plan/hope here is to have...

Hey Guys, I am trying to build sort of a database with a search in it. So, what i am trying to do is: When user enters a text in C7 and hit the button, it searches the text (exact match) in Sheet2(called Data) then displays it in Cell C19. Attached screenshots for more clarity. Thanks a lot in...

Hi All, I need some help with a formula which is not working the way I want it too. I have columns with dates and rows with values, see below: my current formula in column M is: =IFNA(LOOKUP(2,1/((Q10:DA10<>"")*(Q10:DA10<>"Y")),Q10:DA10),"") What it currently does is pick up the last cell...

Hi, I required a formula help for return a values based on lookup location Highest and least values of amount and return a cell addresses of that absolute and relatives in column F, Cells F4 to F9. Sample enclosed a for the reference. Thanks, ABCDEF123ItemsAmountLocationLookup...

I have the following problem.... Cell P9 on Sheet 1 will have a rate that comes from a matrix on Sheet 2 Sheet 2 matrix has descriptions of the operations from cell L5:L50 Sheet 2 has my years across row 4 cells O to Y Sheet 2 has the rates inside the matrix - cells O5:Y50 What I need to...

Hi Guys, Just wanted to ask you have any other way of doing vlook ups in a fastest way. Example: Reference Tab <tbody> ID Name Subject Score Note 001 Ben Math 90 N 002 Ana Science 97 003 Sean Science 85 004 Millie Math 87 </tbody> LookUp File <tbody> ID Name Subject Score Note...

Hi Guys, I'm having a hard time with this. I need a code that will look for a value on multiple sheets and return it's sheet name. So in a workbook I have 4 sheets namely: Raw, Name1, Name2, Name3 & Name4 "Raw" sheet contains names only and as for the other sheets, it has below data...

Hi Guys, Can you possibly help me out on the macro I'm trying to sort out? Basically, I have this excel file named "MasterList" with two tabs sheets namely: Master & Reference. The master contains a list of data while reference sheet has list of countries and its equivalent country group...

Hi All, I have two sheets, Weekly Sales and Yearly Sales. Column A on Weekly Sales has the 7 days of the week running from cells A10:A16, On the yearly sales the dates run from cell A3:A368. The idea is that the weekly sheet is populated and then a macro copies all data from the weekly sheet...

Hi, I need to be able to get an amount spent per month on certain tasks. My spreadsheet has costs for cleaning, repairs, etc corresponding to each month, see below; Jan Feb Mar Cleaning 10 10 10 Repairs 10 10 10 What I want to do is get a total cost per...

So I have this table that looks like this in a sheet called Raw Data: <tbody> A B C D E ... SF 1 Date 1 Date 2 Date 3 Date 4 Date 5 Date ... Date 500 2 Other Other Other Other Other Other Other 3 125487 245875 325665 125452 547854 325658 399856 4 302154 125475 245478 326585 214523...

I have a workbook with 7 sheets containing part number of a product in column and its cost in adjacent column. And the 7th sheet contains total number of parts in all the sheets. I want to change cost of some products but then I have to do the same in all sheets. Is there a way by which it...

I am trying to get a macro code to have an email generate everyday on it's own, with data that changes every day. Basically this is for work, this tracks the dates of employee's corrective action and after 91 days, the corrective action "falls-off" and I need it to generate an email with the...