vlook up problem

I hope you are all well. I have the below macro which works like a charm :-), but it only works if Customer ID is in column A. of the first sheet. (see pic) The issue I now face is that Customer ID is now in Column D and will remain there. Can anyone help and amend my code so that it will work...

I am using Excel VLookup function, but with the function I am getting the values only not the Font color of the cell from which the value is coming out. How to solve the issue ??

Hello, I am in some trouble when trying to use vlook up with multiple conditions. I have read a few threads but I can't seem to make it work for my task. Can you explain me on this example? We have two products in two different storage locations each. I want to see sales matched with the stock...

Typically I would do a vertical look-up for a Supplier name by using a list and based on the ingredient name say Bananas in A1:A90 I can locate and return the Supplier name in C1:C90 however this case I need the capability to find multiple suppliers for that ingredient. One may be the...

I have two tables that I need to match up. Each one contains same entities, but they could be listed different. What is the best way to capture them? Column A Vikings LTD Soul Train Inc Column B Vikings Limited Soul Tr Incorporated Which formula would you recommend to bring back matching...

Need some help with a formula and I'm going to try to formulate what I'm trying to achieve and write down the logic below in steps: 1) Take value in TABLE 1 and Lookup for matching value in TABLE 2 2) If value is found then go 5 fields across (to the right) and bring back the value (value are...

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...

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 need your help to develop an Excel formula that will look up a value and return ALL found values in a separate worksheet. I have the following database and I will like to separate all employees with the same job title in a different worksheet. (I've tried VLOOKUP and ARRAY formulas with no...

Hello, Please could you help me? I am a complete novice at Excel and am trying to save myself lots of time! I need to search for 1502 staff details in Excel 2007. I need to search 9 different tabs to input consolidated info into tab number 10. Each of the 9 tabs contains the following...

HI Guys I am trying to work out how how i get different lookup values based on a selection made in a drop down box. My data is on different sheets. Basically what ever i select in the drop down on cell E on Sheet Sales should determines what Vlookup returns and which sheet it goes to for its...

So i would like to create a league table that has the ability to generate a random (or certainly something that appears random possibly using RAND or RANDBETWEEN) set of plays/matches of singles, doubles and trebles. So on my darts team there is the POSSIBILITY of 4 to 7 players. (THIS...

Hi, I am trying to solve a scenario on excel but not sure what formula to use. What I am trying to achieve is if a work item is completed within 7 days they receive 5 points, if within 14 days then 3 points and if more than 14+ days than 1 point. <tbody> A B C D 1 Work Item...

Data: A : B: Wilbraham John Wagner (first row, row 1) Wilbraham Casey Smith Wilbraham Chris Kavanagh Wilbraham Josh Gorman Springfield Tom White Springfield Elizabeth Crowl I want to be able to lookup wilbraham and receive the the four names that correlate...

Hi, I would like a "lookup" formula that would return the best possible match. (closest match) Example lookup_value - "BUILDING 421" ??? Array column a column b BUILDING 451 Manchester BUILDING 361 Manchester BUILDING 201 Manchester BUILDING 108...

So I have a bunch of duplicates and uniques. I've marked all duplicates with numbers ranging from 1-10 depending on how many duplicates there are. After this, on a different sheet to confirm which quantities are unique and which have duplicates I put...

Hi, I want to do a standard vlookup on a value in a column in spreadsheet 1 and populate a new column cell in that spreadsheet with a cell from spreadsheet 2. But the value im looking up may be repeated a number of times in spreadsheet 2 over different rows. Each time it is repeated, i would...

<TBODY> Hi evryone,</SPAN> I have the following table in sheet-1 from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main table in sheet-1.</SPAN> Example: If I add a row with the name...

I put the the "vlookup" formula in customer Name Column. but it show <tbody> "#N/A"error </tbody>