Posted to microsoft.public.excel.programming

A-DESIGN

external usenet poster

Posts: 40

Question

Hi,
Please see below example of my question:

this yellow table is the source data (given):
HD2A 2775
HD5A 4010
HD6A 5105
HD8A 7460
HD10A 9540
HD14A 11080
HD20A 11080
HD15 15305

PHD2-SDS3 3610
PHD5-SDS3 4685
PHD6-SDS3 5860
PHD8-SDS3 6730

MSTC28 2760
MSTC40 3985
MSTC52 4740
MSTC66 5855

HD2 585
HD5 890
HD6 735

the green numbers are my input data and blue one are output data :
sample-1
2800 HD2A
PHD2
MSTC28

sample-2
8545 HD10A

sample-3
6325 HD8A
PHD6

sample-4
1500 HD2A
PHD2
MSTC28
HD2A

I need to compare green numbers with the numbers on the 2nd column (yellow
table) and obtain the blue names from the 1st column (yellow table) as you
see on above samples.

Thanks in advance.
Afshin K.
A-Design

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel 2007 Macro/VB Question DDE Question	MadDog22	Excel Worksheet Functions	1	March 10th 10 01:47 AM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good	davegb	Excel Programming	1	May 6th 05 06:35 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	0	April 27th 05 07:46 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	23	April 23rd 05 09:26 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you	[email protected]	Excel Programming	0	April 22nd 05 03:30 PM

All times are GMT +1. The time now is 01:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us