I have the above formula set in a workbook.
I have sheet 1 with my main information.
I have sheet 2 with all my directives.
sheet 1 contains:
cell c3= client
cell c4= project
The vlookup I have entered in cell c5 is to return a job number based on the
project in cell c4 which is listed on sheet2.
Problem is, I have multiple projects named the same. They're under different
clients.
I found a post that said I could use:
=vlookup(C3&C4,'Named Fields'!AH3:AM116,6,FALSE)
But that didn't work.
Is there any way to have vlookup find what's in cell C3, then proceed to
cell C4 to returns the results in the 6th column?
I need a formula to look up an ID# from one sheet and return the sum of all cells (in another column) that have the same ID. I have security a security ID number and have a list of all holders of that security, but I need to sum the total value and total shares for a firm wide report.
I am trying to create an automated receipt for a list of artists. I have given the artist an individual reference so I am doing a VLOOKUP to return description/price value etc but I can only get it to return the initial value and I have approx 10-15 works under each reference. Maybe VLOOKUP is the wrong formula to use.. I have attached the file.
I think I am surrounded by trees and can't find the forest, I have a list of tariffs and need to get them to a generic name. The attached file may help, the gist of it is I need to output the generic name for each tariff instead of the supplier name for that tariff.
I want to create a certification only list on a separate tab of training that has been completed where a certification has been issued (as indicated by a "Y" in the "Certification?" column on the training tracking tab) and then populate from some of the fields vs. all of the fields.
What I have now, only pulls the first occurence, not all occurences. I saw that I could have identified the multiple columns that needed to be populated, but it didn't work either, so I'm fine putting a separate vlookup in each column.
I am trying to create a formula which looks in 1 cell to determine 'IF' it states either "BUTT CUT" or "DIE CUT" and then does a VLOOKUP in a table array for each which ever column relates to asnwer to 'IF statement.
This is as far as I have got but even this won't work:
i'm trying to take a selected row of about 7 cells (which are obviously all positioned horizontally) and have it inserted, via vlookup using the drop down option of 'Data Validation', to another location but having all the cells lined up vertically, meaning going down 7 cells. I would guess that a shorter explanation of what i'm trying to do is to have the vlookup transpose 7 cells.
I'm currently doing a survey using an excel workbook that contains multiple questions across multiple worksheets using radio buttons linked to certain cells.
I have around 400 workbooks coming back to me, so what i want to do is take specific values from across many worksheets within each workbook and combine them into a large master table in a seperate workbook.
I've tried using VBA, but not being very proficient at it i've hit a brick wall with that, so i'm hoping that there is an easier way to do it than what i'm currently pursuing.
I have created a spreadsheet to show some reports and I wanted to serch for some datas which overloops themeselves. If you can have a look at a test file I attached you will see the full picture. I have 2 tables, where the 2nd one is on the right side of the 1st one. 1st table:..............
I have a spreadsheet with 5 worksheets. I want VLookup to read the City and State in the two columns next to the County Column in the custmast worksheet. Compare the city and state to the worksheets AL, FL and GA worksheets and return the correct County and Territory Code found in the Territory worksheet in the County Column and Territory Column in custmast worksheet. I've attached a file for better understanding.
Is there such a thing as a multiple value Vlookup? Basically, here's my problem (please refer to image):
On the left are columns for Date, Time and Price. On the right, there is a blank column for Req Price which has to be filled with the corresponding price based on the Req Date and Req Time. So for cell H2, there should be the price that corresponds to 1/4/00 and 8:25:00, which would be 97.00 (which comes from cell C4). If say there is no price that corresponds then the cell is simply filled with an #N/A (which would be the case for cell H4). Then so on and so forth for the remaining cells in column H.
Is there like a Vlookup function wherein you can specify 2 lookup values or something? Or should a macro be used for this sort of thing?
I am trying to simplify a complex array formula using a UDF. I am trying to return multiple corresponding values horizontally. Can this be translated to VBA?
I've used VLOOKUP based on matching one column and returning one result. No problem. Now I need to return one result based on 3 columns matching.
Assume this range of columns is named: TravelDays Origin...Location...ShipVia...TravelDays 33778...420...UPS...3 33778...425...UPS...1 33778...440...UPS...3 33778...443...UPS...3 33778...446...UPS...2 33778...447...UPS...3 33778...449...UPS...5 33778...475...UPS...3
What I'm trying to accomplish is if these columns match: i2=Lookup!TravelDays,1 E2=Lookup!TravelDays,2 N2=Lookup!TravelDays,3
I am trying to create a table which will search for a name throughout several other sheets. All of the same format and layout but with different data. I then need to display information in a different column of the same row of the name I'm searching, just like vlookup.. I also need to be able to search for multiple entries with the same name, so there may be 3 different entries for John Smith thoughout the few dozen sheets.
I have a requirement where I need to look up a resource hierarchy with the region and the product line and then decide the value from the mapping table.
May be I can explain more clear with the workbook example attached.
If a user belongs to Dev & QA * hierarchy, check the region, and correspondingly check the product line, on meeting all these select the value from the mapping table to fetch the expense value from Approval process column of mapping sheet.
I'm trying to create a VLOOKUP that will return a value in 'Tracking' from 1 of 4 different sheets. If the value isn't found in sheet 1, the lookup should continue to sheet 2. If not found in 2, move to 3 and so on. In cases where there is no value, I would like to return " ".
This formula returns values only in sheet 1. It won't continue to 2 and so on. Also, this will return a 0 for a blank value. If working as intended, 'Tracking' will show "g" in B2 and " " in C2.
I've been trying to figure out how to do a vlookup using two conditions. Reading some other posts, I saw this could be done by combining a MATCH function but I'm still having trouble. Here is what I'm trying to do: I am trying to match cash amounts based on two look up values....one being the identifier (cusip) and one being the pmt code. http://i105.photobucket.com/albums/m204/RAK_08/data.jpg
This data is formatted exactly the same but comes from two different sources. I need to match the pmt amounts for a cash reconciliation.
Just learned a little about vlookup and wondering if it can be use to solve the following. I have attached "worksheet1" that shows what I'm trying to do. The "detail" sheet is downloaded from another software package. There may be one to five rows of Product #'s with their component # and percentage on the same row. I would like (on a new sheet) put one Product # and all the corresponding component #'s and percentage's on the same row. (An example of how I would like it to be is on the "one row" sheet.)
I have an excel sheet that contains employee details (Emp. code, Name, Dept. & Shifts for the month) on one sheet (named Manpower) and their respective shifts on other sheets. The emp code in the manpower sheet should be looked up in the other sheets and the corresponding shift on the particular date should be returned. The problem is that since the sheets are arranged by departments the emp code has to be looked up in all the sheets till a value is returned.
I am trying to find a vlookup formulae for multiple spreadsheets in excel. I have the below data that i need to lookup, test and produce an output.
Main Spreadsheet:
Column B...........................Column C A 0000564235.................... <Desc> <---- Desired output is Coumn C from searching all part numbers in each spreadsheet.
Spreadsheet 1:
Column B (Part No.) ..........Column C (Desc) A 0000564235................................Hose
Spreadsheet 2:
Column B (Part No.) .......Column C (Desc) A 02315645646 ............................Clamp
Spreadsheet 3:
Column B (Part No.) .......Column C (Desc)............
I've sorted the second row by price on the second sheet, but how do I get the corresponding category and quantity numbers? A normal Vlookup formula would return '8' twice on (a) and (b), but I need both 8 and 6... So only one value should be returned at both (a) and (b), as long as all different quantities are covered.
I have a list of names I need to look up against another list. My problem is that the second list has a mixed formatting of Firstname Lastname and Lastname Firstname. What I did so far is create a second column that reverses the first and last names in the column.
Table1:
A B
1 Name Name (reversed)
2 John Smith Smith John
3 Jackson Laura Laura Jackson
4 Maxwell Ted Ted Maxwell
5 Chris Hansen Hansen Chris
Table2:
A B
1 Name Currently employed?
2 John Smith =IF(ISNA(VLOOKUP([A1; Table1!A:A;1;FALSE));"NO"; "YES")
3 Laura Jackson
4 Ted Maxwell
5 Chris Hansen
The VLOOKUP formula works great but I need it to look for a matching name across Table1:A:B not just Table1:A:A. How would I do this?
I have multiple worksheets with data for which I would like to write a macro to search and "retrieve" based on the State/County/Municipality and Client selected. I have created the drop down menus that should drive the data being searched, but I'm not confident in my very limited abilities to take this to the next level.
End goal: User should be able to select from the dependent drop down lists (State/County/Municipality) and/or Client, click "Retrieve Data" button and pull in data from the appropriate worksheet driven by the selection in the drop down lists.
I have to extract multiple words from the string using VLookup function.
(Example :"Cell A1 "This is the best example")
Example : Finding "This" from cell A1- result VLookup (Sheet1) A1:D12 Finding "IS" from cell A1- result VLookup (Sheet2) A1:D20 Finding "BEST" from cell A1- result "Excellect" Need to haev function for this
