Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data that is not numerical
I need to create a formula that will go to another workbook and based on
criteria from the original workbook (matching address) return the sales associate for that address. If the address is not found I will need the cell to state "GSI". Similarly I need to do this for the Property Manager column as well using the same criteria. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data that is not numerical
=if(isna(vlookup(your data)),"GSI",vlookup(your data))
-- Hope this helps. Thanks in advance for your feedback. Gary Brown "DMW" wrote: I need to create a formula that will go to another workbook and based on criteria from the original workbook (matching address) return the sales associate for that address. If the address is not found I will need the cell to state "GSI". Similarly I need to do this for the Property Manager column as well using the same criteria. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data that is not numerical
Thanks Gary!
Here is what I need, I tried what you stated and it didn't work very well. I may not have been clear enough, it has been a loooooooooong day. I have provide examples so you can see what I am trying to accomplish: Below is the first spreadsheet where I need the information populated: Marketer is blank and so is property manager at this point. What I need to do is go to another worksheet and get this information. I have provided a copy of the other worksheet below as well. The blank worksheet: Marketer Property Mgmt address 50 E 98th St 505 E 79th St 505 E 79th St 505 E 79th St 50 E 98th St The other worksheet one colum supplies the property management name and another populates the Marketer initials. Please help me to do this, my brain is like mush today! "Management Company Name" BuildingAddress MS Dalton Mgt 4 E 107th St Dan Dalton Mgt 35E 106th St Dan Dalton Mgt 1250 Fifth Ave Dan Dalton Mgt 1590 Madison Ave Dan I appreciate your help! "Gary Brown" wrote: =if(isna(vlookup(your data)),"GSI",vlookup(your data)) -- Hope this helps. Thanks in advance for your feedback. Gary Brown "DMW" wrote: I need to create a formula that will go to another workbook and based on criteria from the original workbook (matching address) return the sales associate for that address. If the address is not found I will need the cell to state "GSI". Similarly I need to do this for the Property Manager column as well using the same criteria. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data that is not numerical
Assumptions:
The Blank Worksheet starts in Cell A1 with 'Marketer' as a header and ends in Cell C6 with '50 E 98th St'. The Other Worksheet starts in Cell A2 with 'Management Company Name' as a header and ends in Cell Cell C5 with 'Dan'. In Cell A2 of the Blank Worksheet, put this formula and copy it down... =INDEX(OtherWksht!$A$1:$C$5,MATCH(C2,OtherWksht!$B $1:$B$5,FALSE),1) In Cell B2 of the Blank Worksheet, put this formula and copy it down... =VLOOKUP(C2,OtherWksht!B:C,2,FALSE) To review 'Index', 'Match' and 'Vlookup', use the Excel Help. -- Hope this helps. Thanks in advance for your feedback. Gary Brown "DMW" wrote: Thanks Gary! Here is what I need, I tried what you stated and it didn't work very well. I may not have been clear enough, it has been a loooooooooong day. I have provide examples so you can see what I am trying to accomplish: Below is the first spreadsheet where I need the information populated: Marketer is blank and so is property manager at this point. What I need to do is go to another worksheet and get this information. I have provided a copy of the other worksheet below as well. The blank worksheet: Marketer Property Mgmt address 50 E 98th St 505 E 79th St 505 E 79th St 505 E 79th St 50 E 98th St The other worksheet one colum supplies the property management name and another populates the Marketer initials. Please help me to do this, my brain is like mush today! "Management Company Name" BuildingAddress MS Dalton Mgt 4 E 107th St Dan Dalton Mgt 35E 106th St Dan Dalton Mgt 1250 Fifth Ave Dan Dalton Mgt 1590 Madison Ave Dan I appreciate your help! "Gary Brown" wrote: =if(isna(vlookup(your data)),"GSI",vlookup(your data)) -- Hope this helps. Thanks in advance for your feedback. Gary Brown "DMW" wrote: I need to create a formula that will go to another workbook and based on criteria from the original workbook (matching address) return the sales associate for that address. If the address is not found I will need the cell to state "GSI". Similarly I need to do this for the Property Manager column as well using the same criteria. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting numerical data | Excel Discussion (Misc queries) | |||
Charting Non-Numerical Data | Excel Discussion (Misc queries) | |||
How do I total non-numerical data | New Users to Excel | |||
extracting numerical data | Charts and Charting in Excel | |||
Non-numerical data in a pie chart | Excel Discussion (Misc queries) |