Copy to corressonding cells

[samusa]

Hi all,
I have an Excel spreadsheet with different columns and the first column has application names. The second column and the rest of columns get data by running different queries in MS access database.Let us assume I have 100 applications listed in first column and I am running a query for second column and it results 50 records. I have to link these 50 records with corressponding application names. Can any one help me out how can I do this.
Thanks!

sam




Sam

 

[Welshbird]

Sam - what do you have that shows you the links between these columns?

It strikes me that a vlookup will do what you require.

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[samusa]

Actually I want to copy results of the query to the second column and it should match with Ist column layout. e,g;
Ist Column Second Column
Bindview
Windows
Visio
....
....
The query returned Ist column and second column results. Now If there are 100 application listed in first column (Master Sheet) and query returned 50 records, How can I copy them in second column of master sheet so that each result will match with corresponding application.

Sam

 

[Welshbird]

then a Vlookup will do exactly what you need. I have a crib sheet explaining how to use this if you need it, but its at work, and its midnight here now, so if you would like a copy, let me know and I'll send you one tomorrow morning. (about 8 hours time?)

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[samusa]

Thanks willif! I will greatly appreciate if you could send it when you get a minute.

Thanks!


Sam

 

[Welshbird]

OK - How can I send it to you then?

Hmm.



Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[Welshbird]

OK - is hidden in the background of my company website!

You can find it here.

Hope it's helpful.

(It's not the best training document in the world, but it might help)

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[Welshbird]

Can you let me know when you have saved a local copy? I'll need to delete it again.

Thanks,

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[samusa]

Thanks! I just saved it. Go ahead and delete it.

Thanks again.

Sam

 

[Welshbird]

Thanks - Have done.

Let us know if you need more help.

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[samusa]

Thanks a ton! It works fine however when I used =VLOOKUP(B3, test, 2, FALSE) , I got #N/A in cells where there was no match. I just want them blank, so I used following:

=IF(ISNA(VLOOKUP(B3, test, 2, FALSE))," ", VLOOKUP(B3, test, 2, FALSE)). This works fine and leaves all those cells blank with no corresponding values except few where I am getting 0 every 20-30 records in this column. Any idea?

Sam

 

[Welshbird]

If you go and search in the lookup list (named range test) is there definately something in column 2 for those values? Could it perhaps be a zero?

(Obvious I know, but check the obvious first).

If not, for at least one of those rows do the standard vlookup but bring back column 1 - this almost has to work. Assuming it does do the ISNA version and bring back column 1.

Post back what you find and I'll see what I can do. Allowing for time differences and the fact sleeping might have to happen at some point!

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]