All,
I am hoping to populate a column with data from another worksheet.
Basically, I have a set of columns, one for Location, Zip Code, Longitude, and Latitude. I want a formula to say, if the location equals X, then pull the associated information from the other worksheet. Any input would be greatly appreciated -- I assume it would be an if or vlookup, or combination.
Welcome to the forum.
it depends.. look for vlookup, index/match, sumproduct functions as your options.
btw you can upload a sample file here so other members could take a peak suggest better solutions.
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Sounds like you need a lookup formula. See if this helps:
http://contextures.com/xlFunctions02.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Attached is an example file. SHEET 1 contains the desired format. SHEET 2 contains the data I would like to insert into SHEET 1. Hopefully this helps.
I am having issues uploading the file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks