vlookup help needed
 

I am using the following syntax.

=VLOOKUP('MIS'!A4:A1000,'Data from MIS'!B4:B1000,A59,FALSE)

I am trying to lookup where 'MIS!A4:A1000' is equal to A59 and return the
contents of the relevant row cell in 'MIS!B4:B1000'

Can someone tell me what I have wrong please

thanks
S

Sorry, my syntax in above was wrong. Iam using:

=VLOOKUP('MIS'!A4:A1000,'MIS'!B4:B1000,A59,FALSE)

"Steven J" wrote in message
...
I am using the following syntax.

=VLOOKUP('MIS'!A4:A1000,'Data from MIS'!B4:B1000,A59,FALSE)

I am trying to lookup where 'MIS!A4:A1000' is equal to A59 and return the
contents of the relevant row cell in 'MIS!B4:B1000'

Can someone tell me what I have wrong please

thanks
S

=VLOOKUP(A59,MIS!A4:B1000,2,FALSE)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Steven J" wrote in message
...
Sorry, my syntax in above was wrong. Iam using:

=VLOOKUP('MIS'!A4:A1000,'MIS'!B4:B1000,A59,FALSE)

"Steven J" wrote in message
...
I am using the following syntax.

=VLOOKUP('MIS'!A4:A1000,'Data from MIS'!B4:B1000,A59,FALSE)

I am trying to lookup where 'MIS!A4:A1000' is equal to A59 and return the
contents of the relevant row cell in 'MIS!B4:B1000'

Can someone tell me what I have wrong please

thanks
S

No, VLOOKUP gets the value not the format.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ACA Marketing"
wrote in message
news:ACA.Marketing.1uc8yh_1125003933.3915@excelfor um-nospam.com...

I am using the VLOOKUP function and it is bringing in the result that I
want - however, it is not bringing in the text color from the
originating cell. (The text it is finding on the first spreadsheet is
blue but when the function returns the answer onto the second
spreadsheet it is black every time.) Is there a way to retain the cell
formatting like colors or background patterns using VLOOKUP??? I am at
a loss. Thanks.


--
ACA Marketing
------------------------------------------------------------------------
ACA Marketing's Profile:
http://www.excelforum.com/member.php...o&userid=26652
View this thread: http://www.excelforum.com/showthread...hreadid=399261

So.... if I can't do that with VLOOKUP does anyone know how to make the
formatting of one cell flow into another using a formula??? By
formatting I do mean colors, backgrounds, font colors, etc. There will
be no value (in fact no entry at all) in the cell that I am referring
to. Assuming "1" means Green, "2" means Yellow, etc., if I enter "1"
in Col A Row 1, I want to have the formatting from a cell on another
spreadsheet flow into Col B Row 2 everytime "1" is entered in Col A. If
I put "2" in Col A, I want Col B's correct row and cell to be Yellow.
What I have is one spreadsheet with a number and color "key" on it and
want to use it to basically automatically fill in information in Cols
B, C, D that correlates with my "1" and "2" in Col A, etc. I have
succeeded with the cells on the key that contain values - using the
VLOOKUP as mentioned earlier - but have one cell on the key that simply
contains a background color. Anyone have any ideas??? Excel may not be
able to accomodate this request, but I just have to believe there is a
way!


--
ACA Marketing
------------------------------------------------------------------------
ACA Marketing's Profile: http://www.excelforum.com/member.php...o&userid=26652
View this thread: http://www.excelforum.com/showthread...hreadid=399261

There seems to be a contradiction in what you are saying (at least as I read
it ;-)). You say you want the format to be picked up from elsewhere, then
you say that if A1 =1 , you want it to be coloured green.

If you are going to codify it, by putting some value in A1, you could use
event code to trap that and do formatting based upon its value.

If you have firm rules it can be done I think.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ACA Marketing"
wrote in message
news:ACA.Marketing.1uchai_1125014738.0451@excelfor um-nospam.com...

So.... if I can't do that with VLOOKUP does anyone know how to make the
formatting of one cell flow into another using a formula??? By
formatting I do mean colors, backgrounds, font colors, etc. There will
be no value (in fact no entry at all) in the cell that I am referring
to. Assuming "1" means Green, "2" means Yellow, etc., if I enter "1"
in Col A Row 1, I want to have the formatting from a cell on another
spreadsheet flow into Col B Row 2 everytime "1" is entered in Col A. If
I put "2" in Col A, I want Col B's correct row and cell to be Yellow.
What I have is one spreadsheet with a number and color "key" on it and
want to use it to basically automatically fill in information in Cols
B, C, D that correlates with my "1" and "2" in Col A, etc. I have
succeeded with the cells on the key that contain values - using the
VLOOKUP as mentioned earlier - but have one cell on the key that simply
contains a background color. Anyone have any ideas??? Excel may not be
able to accomodate this request, but I just have to believe there is a
way!


--
ACA Marketing
------------------------------------------------------------------------
ACA Marketing's Profile:
http://www.excelforum.com/member.php...o&userid=26652
View this thread: http://www.excelforum.com/showthread...hreadid=399261