lookup

Dear All, I have an issue. I have a table that contain salesmen, selling channel, and their achievement. I'd like to fill the incentive column using formula but I don't want to use nested If. I'd like to use lookup table instead. Here is my incentive table Name Channel % Ach. Incentive...

The last argument in XLOOKUP allows performing a binary search but XLOOKUP only returns one match. IF(value=lookup_array,return_array,"") returns all matches in an array but is slow on large lookup ranges/does not do a binary search. Would anyone know a fomula - or combination of - that both...

I have a dataset (reduced mock version below). What I'm trying to do is return the column head for the highest count for site. As an example, Site 1 has the highest count of 15.455, so I'd like Type A returned. The 2nd highest value for Site 1 is 9,708 and this would return Type E. I have...

I have a spreadsheet with 30+ tabs. All tabs have the same columnar setup I need to pull out all rows across all tabs which contain a single value found in a column cell (in this case; column C) Ideally, the report should include the tab name Some customer order numbers exist over different tabs...

HI Team, Need help in attached sheet for looking up value from table with multiple createria which includes 3 column lookup for 2 input and need result from another column with matched createria. Please help. In attached sheet Need D column output by checking G column and H column price...

it has been explained through pictures, how to fiks this problem ? thanks :)

Hi, I am using a formula as follows to pull out the rightmost result in the second row in the column range F to Z: =LOOKUP(2,1/('ABC1'!F2:Z2<>""),'ABC1'!F2:Z2) This works as expected, but I have a number of worksheets, and I'm looking to pull out the rightmost result in the second row in the...

Hey Team, Device ID is not one of the Environ Variables Excel can access. Does anyone know how to lookup the Device ID of the computer you are currently working on using Excel VBA? I can find this variable myself by going to the about section in settings. however I am looking to reference this...

Hi there, I am trying to automate a meeting planner. I have meetings down the rows, employee participants and time of meetings along the columns and market with "x" in the cells. I would now like excel to automatically populate a new "calendar overview"-table with the times down the rows...

I am making a meeting overview of an event. I create each meeting down the rows and mark an "x" under each participant and time of the meeting (both along the columns). Hereafter I would like to make separate cellar overview where it automatically marks "free", "booked" or "double-booked" for...

For example: let's say I have a six-sided die with sides A through F. I roll the die four times and record results per trial as follows: Trial Roll 1 Roll 2 Roll 3 Roll 4 1 A B C D 2 E F A B 3 E D C F Now I have another table where I want to output the roll during which each letter...

I am trying to lookup only "DELIVERED" items and have it look up based on tracking number, then return the date it was delivered from Sheet 2 Col L to Sheet 1 Col J, but ONLY if Sheet 1, Col C status says DELIVERED, otherwise leave blank not some error code like Ref# or something else. Also, how...

Hi, I need some help with the following. I have two workbooks where I need to do a lookup in between and obtain a value. To be more precise there is one active mastersheet which contains all the data, and a map with separate sheets, and each sheet does a lookup on the mastersheet and obtain a...

C2:C7 has single non-sequential numbers and B2:B7 has multiple numbers separated by commas in each cell. I want to match the C2 numbers in B2:B7 and get the output of the corresponding matching number in D2. Can anyone help me formulate this? Thanks

I have these activeX controls fields: EmpNoBox = Employee Number (TextBox) AgeBox = Final result with age (TextBox) **These 2 are located in the "Registro" worksheet In a different worksheet called "Base_Externos" I have a data base with the employees information, employee number is located in...

Hi, I really hope someone can help me make this drop down list. I have a cell that a user will type in a acronym. Cell B1 I have a range of acronyms in a separate tab (about 700 of them). I would like the user to presented with a drop down list of cells within the range that contain those...

Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...

Hi Guys - looking for an expert to help with this one. Having trouble in finding/showing values (E2 | F2 | G2) when there are duplicates in a range (A2:B8). Essentially: Cell E2 - Lookup D2 amongst Column A, display adjacent value (display B3 - 1111A) Cell F2 - Lookup D2 amongst Column A...

I don't even know if this is possible, it was hard enough figuring out the title for this post. So to give context to my problem, I'm given a sheet from our payroll team of all the leave taken in the previous month for each of our locations within the business, and I need to add up the total...

Hi All I have two tables i am trying to look up one for the other. Table A is a list of licenses by Country with the Product names for each. Table B is a list of the Product sales. The same Product code can be sold in different countries are in same cell separated by a semi colon. Does...