suppose i hav two sheets as follows...
SHEET 1
ID location country

1 211
2 315
3 234
4 146
5 254
6 147
7 631
8 942
9 845
10 413



and sheet 2 as


id name customer location region

1 211 steve ford onsite usa
2 315 alex nissan offshore india
3 631 white gm onsite usa
4 146 rishi tata onshore india
5 254 john ford offshore india
6 147 bill ford offshore india
7 295 george nissan onshore usa
8 942 enayan gm onshore usa
9 845 mike tata offshore usa
10 413 ali gm onsite india
11 456 murray gm onsite usa
12 486 tim tata offshore india
13 546 david tata onsite inida
14 896 micheal nissan onsite usa
15 234 alison nissan onsite france


now i have to search sheet2 and fill up sheet 1 with the corresponding
entries....both the sheets are in the same workbook...
if someone can help me it would be great...

Are you looking for a programming answer? Because you can easily do that with
Vlookups.

In Sheet One, Column ("location"), Row 1 enter the formula

=VLOOKUP($A1,'Sheet2'!$A$1:$E$15,4,FALSE)
And copy and paste that down column B...

Then in column C do the same thing, but change the 4 to a 5.

"rishi" wrote:

suppose i hav two sheets as follows...
SHEET 1
ID location country

1 211
2 315
3 234
4 146
5 254
6 147
7 631
8 942
9 845
10 413



and sheet 2 as


id name customer location region

1 211 steve ford onsite usa
2 315 alex nissan offshore india
3 631 white gm onsite usa
4 146 rishi tata onshore india
5 254 john ford offshore india
6 147 bill ford offshore india
7 295 george nissan onshore usa
8 942 enayan gm onshore usa
9 845 mike tata offshore usa
10 413 ali gm onsite india
11 456 murray gm onsite usa
12 486 tim tata offshore india
13 546 david tata onsite inida
14 896 micheal nissan onsite usa
15 234 alison nissan onsite france


now i have to search sheet2 and fill up sheet 1 with the corresponding
entries....both the sheets are in the same workbook...
if someone can help me it would be great...

You have received at least 7 suggestions to use Vlookup in response to 3 or 4
previous postings of the same question. -

rather than keep reposting the same message, perhaps provide more details on
why Vlookup is not the answer you can accept.

--
Regards,
Tom Ogilvy


"rishi" wrote:

suppose i hav two sheets as follows...
SHEET 1
ID location country

1 211
2 315
3 234
4 146
5 254
6 147
7 631
8 942
9 845
10 413



and sheet 2 as


id name customer location region

1 211 steve ford onsite usa
2 315 alex nissan offshore india
3 631 white gm onsite usa
4 146 rishi tata onshore india
5 254 john ford offshore india
6 147 bill ford offshore india
7 295 george nissan onshore usa
8 942 enayan gm onshore usa
9 845 mike tata offshore usa
10 413 ali gm onsite india
11 456 murray gm onsite usa
12 486 tim tata offshore india
13 546 david tata onsite inida
14 896 micheal nissan onsite usa
15 234 alison nissan onsite france


now i have to search sheet2 and fill up sheet 1 with the corresponding
entries....both the sheets are in the same workbook...
if someone can help me it would be great...