Vlookup & If

You're welcome Jac
Post back if you need more help.
Regards
John
"Jac" wrote in message
...
John! You are legend! That is precisely what I wanted to achieve - many
thank yous.

"John" wrote:

Hi Jac
I'm not sure what you want but try this :
=IF(Mastersheet!$K$4=Contractor1!$A$1,Mastersheet! A4,"")
Copy this formula in any cell, any worksheet and drag across 7 rows and that
should do it, if I understand your question.
HTH
John
"Jac" wrote in message
...
Guys, am flappin my wings, but i aint flyin....Please, can anybody help me?
Have been trying to get lift off for days. Have given up on the macro and
am
trying for a simple little old vlookup formula that will bring my
information
across to each of my worksheets, cell by pitiful cell. Have changed my
spreadsheet around many, many times now and what I want to do is: bring
info
from MASTERSHEET A4:G4 when sheet CONTRACTOR1 matches A1 with MASTERSHEET
K4.
Anxiously awaiting any replies before I slip into the black hole of excel.



"Jac" wrote:

Hi, I have a workbook, Master sheet containing this info :cell A4
contractor
name, B4 site location, c4 job cost etc to G4. There are several
contractors
for the one job, so it may be that a4-a12 contain a contractor name, and
cells c4-g4 are the only cells that have information entered relevant to
all
in a4-a12. I then have a worksheet for each contractor. What I need to
do
is enter a formula in the individual contractor worksheets that pulls
across
the information for each job (up to say 500rows, all roughly the same as
example above). the formula I have entered is only bringing across line
a4-g4 for the contractor who's name appears at a4, and not bringing across
the info relating to him at say cell a25. Using excel '07. Can anybody
help
me? Auto filter no good, as I need the individual contractor sheets for
other uses, and must have the info separated out.

Any help much appreciated.



.

Thanks again John, quick question for my next flying attempt: what does the
"""" part of your formula mean/do?



"John" wrote:

You're welcome Jac
Post back if you need more help.
Regards
John
"Jac" wrote in message
...
John! You are legend! That is precisely what I wanted to achieve - many
thank yous.

"John" wrote:

Hi Jac
I'm not sure what you want but try this :
=IF(Mastersheet!$K$4=Contractor1!$A$1,Mastersheet! A4,"")
Copy this formula in any cell, any worksheet and drag across 7 rows and that
should do it, if I understand your question.
HTH
John
"Jac" wrote in message
...
Guys, am flappin my wings, but i aint flyin....Please, can anybody help me?
Have been trying to get lift off for days. Have given up on the macro and
am
trying for a simple little old vlookup formula that will bring my
information
across to each of my worksheets, cell by pitiful cell. Have changed my
spreadsheet around many, many times now and what I want to do is: bring
info
from MASTERSHEET A4:G4 when sheet CONTRACTOR1 matches A1 with MASTERSHEET
K4.
Anxiously awaiting any replies before I slip into the black hole of excel.



"Jac" wrote:

Hi, I have a workbook, Master sheet containing this info :cell A4
contractor
name, B4 site location, c4 job cost etc to G4. There are several
contractors
for the one job, so it may be that a4-a12 contain a contractor name, and
cells c4-g4 are the only cells that have information entered relevant to
all
in a4-a12. I then have a worksheet for each contractor. What I need to
do
is enter a formula in the individual contractor worksheets that pulls
across
the information for each job (up to say 500rows, all roughly the same as
example above). the formula I have entered is only bringing across line
a4-g4 for the contractor who's name appears at a4, and not bringing across
the info relating to him at say cell a25. Using excel '07. Can anybody
help
me? Auto filter no good, as I need the individual contractor sheets for
other uses, and must have the info separated out.

Any help much appreciated.



.


.

Hi Jac
quick question for my next flying attempt: what does the
"" part of your formula mean/do?
IF(Mastersheet!$K$4=Contractor1!$A$1 if the answer is no, you get a blank
cell.
2 double quotation mark no space in between.
You can type a word (s) in between the quotation mark if you don't want it blank
Try it.
Hope that helps
Regards
John
"Jac" wrote in message
...
Thanks again John, quick question for my next flying attempt: what does the
"" part of your formula mean/do?



"John" wrote:

You're welcome Jac
Post back if you need more help.
Regards
John
"Jac" wrote in message
...
John! You are legend! That is precisely what I wanted to achieve - many
thank yous.

"John" wrote:

Hi Jac
I'm not sure what you want but try this :
=IF(Mastersheet!$K$4=Contractor1!$A$1,Mastersheet! A4,"")
Copy this formula in any cell, any worksheet and drag across 7 rows and
that
should do it, if I understand your question.
HTH
John
"Jac" wrote in message
...
Guys, am flappin my wings, but i aint flyin....Please, can anybody help
me?
Have been trying to get lift off for days. Have given up on the macro
and
am
trying for a simple little old vlookup formula that will bring my
information
across to each of my worksheets, cell by pitiful cell. Have changed my
spreadsheet around many, many times now and what I want to do is: bring
info
from MASTERSHEET A4:G4 when sheet CONTRACTOR1 matches A1 with
MASTERSHEET
K4.
Anxiously awaiting any replies before I slip into the black hole of
excel.



"Jac" wrote:

Hi, I have a workbook, Master sheet containing this info :cell A4
contractor
name, B4 site location, c4 job cost etc to G4. There are several
contractors
for the one job, so it may be that a4-a12 contain a contractor name,
and
cells c4-g4 are the only cells that have information entered relevant
to
all
in a4-a12. I then have a worksheet for each contractor. What I need
to
do
is enter a formula in the individual contractor worksheets that pulls
across
the information for each job (up to say 500rows, all roughly the same
as
example above). the formula I have entered is only bringing across
line
a4-g4 for the contractor who's name appears at a4, and not bringing
across
the info relating to him at say cell a25. Using excel '07. Can
anybody
help
me? Auto filter no good, as I need the individual contractor sheets
for
other uses, and must have the info separated out.

Any help much appreciated.



.


.

Thanks John, you've been a great help!!!

"John" wrote:

Hi Jac
quick question for my next flying attempt: what does the
"" part of your formula mean/do?
IF(Mastersheet!$K$4=Contractor1!$A$1 if the answer is no, you get a blank
cell.
2 double quotation mark no space in between.
You can type a word (s) in between the quotation mark if you don't want it blank
Try it.
Hope that helps
Regards
John
"Jac" wrote in message
...
Thanks again John, quick question for my next flying attempt: what does the
"" part of your formula mean/do?



"John" wrote:

You're welcome Jac
Post back if you need more help.
Regards
John
"Jac" wrote in message
...
John! You are legend! That is precisely what I wanted to achieve - many
thank yous.

"John" wrote:

Hi Jac
I'm not sure what you want but try this :
=IF(Mastersheet!$K$4=Contractor1!$A$1,Mastersheet! A4,"")
Copy this formula in any cell, any worksheet and drag across 7 rows and
that
should do it, if I understand your question.
HTH
John
"Jac" wrote in message
...
Guys, am flappin my wings, but i aint flyin....Please, can anybody help
me?
Have been trying to get lift off for days. Have given up on the macro
and
am
trying for a simple little old vlookup formula that will bring my
information
across to each of my worksheets, cell by pitiful cell. Have changed my
spreadsheet around many, many times now and what I want to do is: bring
info
from MASTERSHEET A4:G4 when sheet CONTRACTOR1 matches A1 with
MASTERSHEET
K4.
Anxiously awaiting any replies before I slip into the black hole of
excel.



"Jac" wrote:

Hi, I have a workbook, Master sheet containing this info :cell A4
contractor
name, B4 site location, c4 job cost etc to G4. There are several
contractors
for the one job, so it may be that a4-a12 contain a contractor name,
and
cells c4-g4 are the only cells that have information entered relevant
to
all
in a4-a12. I then have a worksheet for each contractor. What I need
to
do
is enter a formula in the individual contractor worksheets that pulls
across
the information for each job (up to say 500rows, all roughly the same
as
example above). the formula I have entered is only bringing across
line
a4-g4 for the contractor who's name appears at a4, and not bringing
across
the info relating to him at say cell a25. Using excel '07. Can
anybody
help
me? Auto filter no good, as I need the individual contractor sheets
for
other uses, and must have the info separated out.

Any help much appreciated.



.


.


.

You're welcome Jac
Regards
John

"Jac" wrote in message
...
Thanks John, you've been a great help!!!

"John" wrote:

Hi Jac
quick question for my next flying attempt: what does the
"" part of your formula mean/do?
IF(Mastersheet!$K$4=Contractor1!$A$1 if the answer is no, you get a
blank
cell.
2 double quotation mark no space in between.
You can type a word (s) in between the quotation mark if you don't want it
blank
Try it.
Hope that helps
Regards
John
"Jac" wrote in message
...
Thanks again John, quick question for my next flying attempt: what does the
"" part of your formula mean/do?



"John" wrote:

You're welcome Jac
Post back if you need more help.
Regards
John
"Jac" wrote in message
...
John! You are legend! That is precisely what I wanted to achieve -
many
thank yous.

"John" wrote:

Hi Jac
I'm not sure what you want but try this :
=IF(Mastersheet!$K$4=Contractor1!$A$1,Mastersheet! A4,"")
Copy this formula in any cell, any worksheet and drag across 7 rows and
that
should do it, if I understand your question.
HTH
John
"Jac" wrote in message
...
Guys, am flappin my wings, but i aint flyin....Please, can anybody
help
me?
Have been trying to get lift off for days. Have given up on the
macro
and
am
trying for a simple little old vlookup formula that will bring my
information
across to each of my worksheets, cell by pitiful cell. Have changed
my
spreadsheet around many, many times now and what I want to do is:
bring
info
from MASTERSHEET A4:G4 when sheet CONTRACTOR1 matches A1 with
MASTERSHEET
K4.
Anxiously awaiting any replies before I slip into the black hole of
excel.



"Jac" wrote:

Hi, I have a workbook, Master sheet containing this info :cell A4
contractor
name, B4 site location, c4 job cost etc to G4. There are several
contractors
for the one job, so it may be that a4-a12 contain a contractor name,
and
cells c4-g4 are the only cells that have information entered
relevant
to
all
in a4-a12. I then have a worksheet for each contractor. What I
need
to
do
is enter a formula in the individual contractor worksheets that
pulls
across
the information for each job (up to say 500rows, all roughly the
same
as
example above). the formula I have entered is only bringing across
line
a4-g4 for the contractor who's name appears at a4, and not bringing
across
the info relating to him at say cell a25. Using excel '07. Can
anybody
help
me? Auto filter no good, as I need the individual contractor sheets
for
other uses, and must have the info separated out.

Any help much appreciated.



.


.


.