You are here: HomeExcelTutorials

# function to pull cell information from column based on cell location

## function to pull cell information from column based on cell location

Price: FREE

I wish to grab a cell value from one sheet and bring it to another based on a previous cell from the same row on the original sheet compared to the column on the second sheet.
For instance
Sheet 1
A 1
B 2
C 3
Sheet 2
B Formula
C Formula
A Formula
Formula should make sheet 2 look like this
Desired Result
B 2
C 3
A 1
please also see attached excel sheet for example
I have gotten pretty close with
=IF(ISERROR(MATCH(A2,Sheet1!\$A\$2:\$A\$8,0)),"Missing",Sheet1!B2)
but of course that ends up pulling
B 1
C 2
A 3
which obviously is not what we are shooting for

Visit publisher's web-site: function to pull cell information from column based on cell location

Category and Tags: ExcelTutorials :

## Related Tutorials

### Formula Based on the cell its in

Free: Yes
Tags: Excel › Functions

If I have a formula in a cell can base its content off that cell. What I mean is say in E2 I have the following equation =IF(SUM(F6:L6)>0,SUM(F6:L6),""). I want to format it so it would be something like0=IF(SUM((F[CELL
LOCATION+4]:L[CELL LOCATION+4])>0,SUM(F[CELL LOCATION+4]:L[CELL
LOCATION+4]),""). I know this is a correction function, but I just want to explain what I mean

### How to populate a cell with numeric value based on textselected from pull down in adjacent cell?

Free: Yes
Tags: Excel ›

How do I populate a cell with a numeric value based on the text selection from a pull down in another cell?
For example, the values available from the cell pull down in column A are "High", "Medium", and "Low".
I would like the adjacent cells in column B to populate with a numeric value based on what was selected from the pull downs in column A.

### Information pull function

Free: Yes
Tags: Excel ›

In column A I have a bunch of job numbers, with information in both column E and F for each job. I have a subset list in column I that are all specific jobs from jobs in A.
Basically, I want to find out if the job in I is in column A, and if so, I need it to show the information from column F.

### If formula based on cell formats

Free: Yes
Tags: Excel › Functions

Is there a way to use an IF formula to pull information from cells based on whether the formatting of the cell matches the criteria formatting.
ie.in words, I'd like to do this.
If F1 is shaded with the dot pattern, pull A1:E1 to a summary sheet.
I already have an array-entered IF formula that currently says:
If F1 = "a", pull A1:E1 to the summary sheet.I just want to see if formatting can be recognized with normal formulas.

### Hide cell based on value of another cell

Free: Yes
Tags: Excel › Functions

Is there a function or something I can use to hide a cell based on the value of another cell?
For example, I want to hide the information in cell B5 if cell A5 doesn't have any information in it

## Related Applications & Scripts

### PHP Map + Location Plugin

Free: No
Tags: PHP › Excel Geolocation

This is a collection of location based functions that can get a users location based on their ip address using the IPInfoDB api, return advanced details on a specific location with the Yahoo PlaceFinder api, or dynamically create maps (as images or with javascript) using the Google Maps api.
This function interacts with the IPInfoDB.com API to get a users location based on their IP address. It can return city, state, country, latitude & longitude and is accurate within a 25 mile radius. This function accepts an IP Address and returns an array of location based values.

### Location oracle - display different content based on the user location

Free: No
Tags: PHP › Excel Geolocation

Location oracle is a GeoIP toolbox that allows to show personalized content on your website based on the user location. It supports the two main GeoIP services (infoDB and Maxmind) and can revert to a zip database if the location service fails to find the correct information. Users can change their location at any time granting the best user experience on the market. This package includes the Zip Codes database for both United States and Australia, you can easily add your own custom tables to cover every area of the world you need, if you don’t have a mySQL database, don’ t worry, Location Oracle will still find the location of your user! Location Oracle sports an advanced caching system that makes this script lightweight but powerful and less dependent on the APIs.

### GG-Tracker GPS and GSM Tracking

Free: Yes
Tags: PHP › Excel Geolocation

GG-Tracker tracks your mobile using GSM Cell-location in combination with GPS and displays your position on the internet using Google Maps. If only a GSM network is available it retreives your location from its database of GSM cells or through CellDB.org

### GMap - PHP Google Maps

Free: No
Tags: PHP › Excel Google Maps

GMap provides a PHP wrapper around the Google Maps Javascript API. Its purpose is to allow a web developer to easily add Google Maps and driving directions to web pages using PHP.
Features
Eliminates the need for special header and body tags, making it easier to integrate into existing sites.
Automatically centers and zooms maps to display all location markers.
Includes current traffic information (in selected cities).
Customizable marker icons and info windows.
Location function obtains geocding information (including latitude and longitude) for any address string recognized by Google.

### Micro Guestbook

Free: Yes
Tags: PHP › Excel Guestbooks

Micro guestbook is a free MySQL based guestbook script with a CSS based attractive interface. It can store the name, date, message, location, web and email information of the visitor.