The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
2answers
145 views

How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?

I'm trying to get Excel to give me information in Column C based on the values in Columns A and B. Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...
1
vote
2answers
88 views

Formula to search highest value related to a near match reference

I have a list of neutral references which change as per the date so What I am looking for is a formula that will search Product and return the latest date. e.g., A B ...
0
votes
2answers
676 views

MS Excel using multidimensional lookup

Hi am trying to assign a value given that if I have a some value that matches column 1, it will search try to check if for that specific row my my product variable is lesser than specified. So let's ...
0
votes
2answers
217 views

Camera control box plugged into the router, any idea how I can find its IP?

In the past I've used it but recently I got a new router. I plugged the camera control box in, and it has an internal webserver to configure it. However I just have no idea what its IP address is. I ...
0
votes
1answer
34 views

in ms excel, is there a way to look up an array and edit data on the looked up row?

Just for a quick example, I have this table: A B 1 student grade 2 john 90 3 paul 93 4 peter 87 5 bill 84 6 7 Range or array is A2:B5. I ...
0
votes
1answer
42 views

Looking up the row number of a shared identifier in Excel, and counting the number of cells in that row that meet specific criteria?

I have a sheet that contains a lookup value in columns. I want Excel to look for each value in another sheet, and count the number of instances of a certain word in the row in which it found that ...
0
votes
1answer
2k views

How to automatically populate a lookup column in Sharepoint 2013

I have 2 Sharepoint lists in SP2013: Errors and Locations. The errors list has a lookup column to the locations list. I need the location information (phone, address, etc) to populate automatically ...
0
votes
1answer
75 views

Excel look-up column data

I have two data tabs for survey responses - the first shows the full set of exepcted responses an which office they are from HMIP LDU 1 Leeds 2 Leeds 3 Leeds 4 Leeds 5 Wakefield ...
-1
votes
1answer
32 views

Excel lookup table based on time

I need to set up a way that I can tell which shift certain things happen in. I have a table that has all the times, but I would like to attach each time to a shift (i.e. if this happens between 14:00 ...
-1
votes
1answer
204 views

Finding the largest value in a 2-dimensional range and returning the column header

I've been struggling to find a solution to locating the maximal number within a 2-dimensional range and then looking up the column header that the maximal number falls into. For example: I'm ...
2
votes
0answers
70 views

Chrome - Selected Text - Right Click [LOOK UP] - How to disable

After some recent update Chrome fro Mac got this SUPER ANNOYING feture. When you select text and right click it, menu comes up. I often used "Search Google for" but now the first thing in menu is LOOK ...
1
vote
0answers
43 views

Trouble adding values from different ranges in excel

I have a fairly unique problem I am having trouble with. Essentially, I need to fix column U on Sheet 1. Ignore stuff out of the tables, as most of that is stuff I either will hide but reference, or ...
0
votes
0answers
30 views

Search tool using keywords on Excel data or a keyword based corresponding code and description search : The file needs permission

I am a basic level Excel user. I need some help on preparing a look-up tool using keywords as described below: I have a list of 1000 different product/service descriptions along with their respective ...
0
votes
0answers
78 views

Domain name lookup as another domain name

In Windows (8.1) hosts file contains mappings of IP addresses to host names. For example: 127.0.0.1 example.domain.net What I want to achieve is to map a domain name to another domain ...