vlookup & if

i have a certain reimbursement rate for certain zip codes. There are 2 levels, rural and super rural. Each has its own rate of reimbursement. For instance, Rural is 284.75, while super rural is 349.10-for one particular service (A0426) Part of the problem is that there are different...

Dear All, I need some help on IF function. I have a sheet in below format In the Overall results (2nd Image) section ,I want another formula to calculate pass, needed attention and fail ,this should be done by dividing sample size by errors identified For ease attaching file...

for example I have two Sheets "DATA" "RAW DATA" In DATA sheets <tbody> APPLE 10 APPLE 15 APPLE 16.5 BANANA 35 BANANA 20 BANANA 36 ORANGE 45 ORANGE 15 ORANGE 50 ORANGE 111 </tbody> In RAW DATA sheet in Column B I have to input APPLE/BANANA/ORANGE in various rows. I...

I have a large excel table listing a number of duplicated project names on the vertical axis (depicting different milestone dates for each project), represented against a number of impact types in the horizontal axis, calling out for each line item if there's an impact or not, and what type of...

hello, I needed to do a text based vlookup on two country fields. The issues were that sometimes the countries were not spelt the same in either sheet e.g. in sheet A = Taiwan, sheet B = Taiwan, province of China. I eventually came up with a formula that works but it’s pretty big and...

Hello All, I could use some assistance on a lookup scenario! I would like to populate a cell with a person's name if they meet certain criteria. For instance: If the person is assigned to a particular team and If the assignment is above 0. if not, the cell should remain blank. Please help...

Hello! I have a spreadsheet that I'm using with three different sheets (Sheet1, Sheet2, Sheet3). In Sheet 1 I have a dropdown list (C4) that contains 20 types of licenses. When a license is clicked, cells c2:c4 will autopopulate with what type of test the person needs for the license (there...

HI All - I am trying to perform a VLOOKUP on a value A. Once I find that value A in a range, I need to also check if value B or value C exists in that row under a different column. I've searched a few threads regarding Index and Match but I'm sure its what i need. Any help is much appreciated!

I have a need to write a formula the if a cell equals a specific range of values and another cell, via vlookup on another sheet equals a specific value, then make the active cell a ZERO, other wise complete a calculation. For instance I need a composite of this =IF((K248=####) "Where the ####...

Hi All, I'm trying to pull employee rates into an hour report - the hour report is by day, however, the rate table is summarized into date ranges with multiple lines per employee. I'm hoping there is a way to do this without having to rearrange the rate table format - see below, thanks in...

<tbody> Order Date Customer Order Number Order Number Position Number Item SKU Order Quantity (Packs) Comments 21/12/2015 2000145943 708817101 133 LCLARCT387-0375125160 -0375125160 1 1/1/1970 12:00:00 AM </tbody> So...

Hi Guys, I am trying to run a report for dates for product supply and so far I have managed to use VLOOKUP to bring me back the dates for all of the products I am reporting but I now want to improve the report by providing a value other than dates such as " made to order" for products that have...

Hi Guys, My first post so I thought I better make it a good one :) I am trying to run a report for dates for product supply and so far I have managed to use VLOOKUP to bring me back the dates for all of the products I am reporting but I now want to improve the report by providing a value...

I wonder if someone could help, I have two supplier lists. The first has the correct supplier spellings and supplier references. The second is a creditor listing from a different system which has the same suppliers and different account numbers. The supplier names differ slightly eg limited...

I have 4 columns (A: Cat#,B: Member#,C: Vendor#, D: Price) on Sheet1. Columns A thru C on Sheet 1 has a different number in Rows 2 thru 10 and Column D is blank to enter the VLookup formula. On Sheet 2 I have 2 Columns (A: Cat#, B: Price). Column A: has several rows with numbers and Column B...

Hello, I'm not fab at excel, but know there is a formula for pretty much anything! So I'm hoping someone can help me. I have a spread sheet with a list of references in rows, 1 reference can be duplicated over a number of rows with a verity of status': Column A (Reference)_____________Column...

Hello, I am trying to use the VLOOKUP function whereby it will firstly lookup the value in cell A1 in 'sheet2' and display a column, but if it cannot find a match, i then want it lookup the same value in 'sheet3'. I am struggling with the formula for this - whether to use...

I have a range of cells in a column that contain the text "In Process" and "Completed". I want to search or vlookup the cells and return "In Process" if any of the cells in the range indicate "In Process". If all of the cells indicate "Completed" I would like to return the value "Completed"...

Hi all, I have a bit of an issue and thought this might be a good place to get some ideas. I have a set of data with client ID going vertically down and then horizontally I have the date the client moved to a certain status. I want to know at any given time how many clients are in each...

I need help to resolve the problem of why the VBA for pasting formula works fine but not for pasting value which result with #VALUE! Below are the abstract two VBA lines. Any suggestion on what to change or modify. 1. Pasting formula works fine. Cells(.Row, "AC").Formula =...