LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
taxmom
 
Posts: n/a
Default What Functions should be used

1stworksheet
City/Couty Gross Tax

county name (formula) Formula
city Name (formula Formula

2nd worksheet (data)
City name County Name Gross amount tax amount

I need to match the city county name from worksheet 1 with the city county
name in worksheet 2 and then bring over from the data worksheet the amounts
from column 4 & 5.

What would I use? I have a Vlookup but it is only searching for the city
name, and I need both. How would I link the search for city and the search
for county?

I have not been able to come up with the right formula to make this work. I
have been trying for days.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PivotTable canned functions doco Excel Discussion (Misc queries) 0 January 14th 05 03:52 PM
Changing the language of built-in functions? Gustaf Liljegren New Users to Excel 3 December 20th 04 08:31 PM
How to load Engineering Functions into the Fx function wizard? jsaval Excel Worksheet Functions 1 November 11th 04 09:47 PM
AND and IF Functions fosterp Excel Worksheet Functions 2 November 10th 04 05:36 PM
Where can I see VBA code for financial functions? eios Excel Worksheet Functions 1 November 2nd 04 01:00 PM


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"