Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default HLookup and If Functions

How do I pull data from incoming data worksheet to destination wksht?

1st worksheet (destination)
M-YY
Product 1 label 1 Criteria 1 LOB1
Product 1 label 1 Criteria 2 LOB1
Product 1 label 1 Criteria 3 LOB1
Product 1 label 1 Criteria 4 LOB1
Product 1 label 1 Criteria 5 LOB1
Product 1 label 1 Criteria 6 LOB1
Product 1 label 1 Criteria 7 LOB1
Product 1 label 1 Criteria 8 LOB1
Product 1 label 2 Criteria 1 LOB1
Product 1 label 2 Criteria 2 LOB1
Product 1 label 2 Criteria 3 LOB1
Product 1 label 2 Criteria 4 LOB1
Product 1 label 2 Criteria 5 LOB1
Product 1 label 2 Criteria 6 LOB1
Product 1 label 2 Criteria 7 LOB1
Product 1 label 2 Criteria 8 LOB1

2nd worksheet (incoming data)


label 1 label 2 and so on
product 1 Criteria 1 LOB1 1
product 2 Criteria 2 LOB2 2
product 3 Criteria 3 LOB1 3
product 4 Criteria 4 LOB2 4
product 5 Criteria 5 LOB1 5
product 1 Criteria 6 LOB2 6
product 2 Criteria 7 LOB1 7
product 3 Criteria 8 LOB2 8
product 4 Criteria 1 LOB1 9
product 5 Criteria 2 LOB2 10
product 1 Criteria 3 LOB1 11
product 2 Criteria 4 LOB2 12
product 3 Criteria 5 LOB1 13
product 4 Criteria 6 LOB2 14
product 5 Criteria 7 LOB1 15
product 1 Criteria 8 LOB2 16

--
MF

Reply
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
efficiency: database functions vs. math functions vs. array formula nickname Excel Discussion (Misc queries) 2 July 14th 06 04:26 AM
Hlookup/max value? swjtx Excel Worksheet Functions 4 December 19th 05 12:45 AM
How to see columns from which values were not returned by HLOOKUP functions? Dmitry Kopnichev Excel Worksheet Functions 1 October 14th 05 12:04 AM
Need help with HLOOKUP and MATCH functions BEAR94 Excel Worksheet Functions 1 August 12th 05 05:36 AM
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... [email protected] Excel Worksheet Functions 2 April 6th 05 09:59 PM


All times are GMT +1. The time now is 09:04 PM.

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

About Us

"It's about Microsoft Excel"