Match Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick - 26 Sep 2007 15:22 GMT

Trying to Match information on two different worksheets and populate a
cell if a match is found

Worksheet A,
Column A=Server names
Worksheet B,
Column A=Server names
Column D=Need Formula that looks in Worksheet A, Column A and looks
for a match for the Server name that is in Worksheet B, Column A, Row
I'm in. if match found put in Server name.

how can I do this

thanks
Rick

Reply to this Message

Michael - 26 Sep 2007 16:40 GMT

on d1 Sheet A:
=VLOOKUP(A1,Sheet1!$A:$A,1,FALSE)

Signature

If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

> Trying to Match information on two different worksheets and populate a
> cell if a match is found
[quoted text clipped - 11 lines]
> thanks
> Rick

Reply to this Message

Rick - 26 Sep 2007 19:40 GMT

On Sep 26, 11:40 am, Michael <Mich...@discussions.microsoft.com>
wrote:

> on d1 Sheet A:
> =VLOOKUP(A1,Sheet1!$A:$A,1,FALSE)
[quoted text clipped - 22 lines]
>
> - Show quoted text -

thanks that worked
Rick

Reply to this Message