I have a spreadsheet that has the information from a Realtor office. It has all the information from each sale for all Realtors. I need to pull certain information off of this main sheet for each Realtor (I will be making a separate sheet for each Realtor). I would use VLOOKUP but not sure how to set it up with all the other information on there.
Date MLS Address Seller Lead Listing Agent Buyer Lead2 Buyers Agent Gross Sales Sale $ Commission Total Commission Co-broke In Office Agent Split Agent 5% Gift
I need to pull off certain columns if the Listing Agent or Buyers Agent is in this office.
If anyone can help me I would greatly appreciate it.
It gives me three links to share. Here are all three:
Download Page: http://speedy.sh/FngS2/Sample-Report.xlsx
Forum Link: [code]http://speedy.sh/FngS2/Sample-Report.xlsx[/code]
HTML Code: <a href="http://speedy.sh/FngS2/Sample-Report.xlsx">Download at SpeedyShare</a>
If you send me your e-mail I can send it to you - mine is email@example.com
sorry your earlier ref is ok. that is download page. I did a mistake
ok I downloaded your file
in sheet 2 see the extract from row 11 I have give below. better use index match function. see the formula in the fists row in column B and C which is copied down
write similar formulas for other columns