Help with data manipulation between 2 worksheet tabs

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

I have 2 sheets. The first contain a number in 11 consecutive cells and the
other sheet contains the same number in 6, sometimes, consecutive cells. What
I need to do is go into the second sheet and for each cell that contains that
number, I want to extract values from other cells in the same row and put
them in sheet1. i.e.

SHEET1

Site ID NAT ID Priority Status Descrp
Amount
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1
3822 070G3822 1


SHEET2

Site ID NAT ID Priority Status Descrp
Amount
3822 070G3822 1 Approved Nothing
$1000
4312 551G3801 2 Approved
$500
3822 070G3822 1 Approved Nothing
$1000
3822 070G3822 1 Approved Nothing
$1000
4313 551G3803 1 Approved
$2000
3822 070G3822 1 Approved Nothing
$1000
6332 551G4801 2 Approved
$700
5322 551G8801 2 Approved
$200
3822 070G3822 1 Approved Nothing
$1000
3822 070G3822 1 Approved Nothing
$1000

So, I need to extract the values in sheet2 columns: Status, Descrp and
Amount; and put them in the corresponding columns in sheet1. As you can see
in sheet2, the site id are not consecutive as in sheet1. I am really stumpped
and I don't know what to do.
Please Help !!!!!!!!
 
Hi,

Try this:

in the sheet1 enter the formulas below:

for status (say column D)
=VLOOKUP(A2,Sheet2!$A$2:$F$100,4,false)
for Descrp (say column E)
=VLOOKUP(A2,Sheet2!$A$2:$F$100,5,false)
for Amount (say column F)
=VLOOKUP(A2,Sheet2!$A$2:$F$100,6,false)

ranges can be changed to whatever you want
you can copy the formula to where ever you want

Thanks,
 
Thanks Farhad but it is more complecated than that. The cloumns in both
sheets don't correspond like I have it in my post. Actually, the columns in
sheet2 are quite dispersed and don't match up with sheet1 exactly. That is
the problem I am having.
 
So you need to send your file to me if i could fix it i will send to you and
if not you will receive nothing. (e-mail address removed)

Thanks,
 
Back
Top