LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default multiple sheet lookup or match

I have multiple worksheets. If column G on 1st page <"Resolved" I want to
match (or maybe lookup?) column A on 2nd page with column A on 1st page and
returning the value of column G on 2nd page. Data will never be more than 100
rows per page. Formula will be placed in column L.
 
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
Index lookup with multiple match criteria Vance K[_2_] Excel Worksheet Functions 5 July 18th 09 07:08 AM
Lookup and match then return data from another sheet Charlie510 Excel Worksheet Functions 6 October 23rd 08 09:14 PM
lookup single value in one sheet, return multiple results from theother sheet Chuck[_3_] Excel Worksheet Functions 1 April 4th 08 06:17 AM
Check if 2 cells match on another sheet then lookup value sarahmarsden Excel Worksheet Functions 1 October 20th 06 12:19 PM
Double and Multiple Lookup Using the MATCH Function Charles793 Excel Worksheet Functions 0 May 11th 06 01:46 PM


All times are GMT +1. The time now is 08:30 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"