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: 7
Default Lookup or an alternative

I have several sheets and I am trying to pull data from the master to the
others, I have been trying to use the Lookup and IF function. But I cant
get the right mix any help would be appreciated.

EX.

Col. 1 Col. 2 Col. 3
Job#'s Item#'s Dates
2556,2554 331 12/09/09
All 332 10/25/09
2554, 333 08/15/09
2558 334 12/09/09
2556,2554 335 10/25/09

Im trying to lookup by job #.
 
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
Alternative to using 10 V-lookup formulas Tami Excel Worksheet Functions 3 April 16th 09 10:00 PM
Returning an alternative value if lookup cannot be found in array Queen_Of_Thebes Excel Discussion (Misc queries) 4 September 2nd 08 01:43 AM
Alternative to IF Dave P[_2_] Excel Worksheet Functions 7 March 28th 08 05:00 PM
Get Cell Address From Lookup (Alternative to Lookup) ryguy7272 Excel Worksheet Functions 12 September 28th 07 10:36 PM
Case specific LOOKUP alternative dan Excel Discussion (Misc queries) 4 June 5th 06 12:22 PM


All times are GMT +1. The time now is 03:24 PM.

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"