Thread: Match Cells
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick[_2_] Rick[_2_] is offline
external usenet poster
 
Posts: 7
Default Match Cells

On Sep 26, 11:40 am, Michael
wrote:
on d1 Sheet A:
=VLOOKUP(A1,Sheet1!$A:$A,1,FALSE)

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

Michael Arch.



"Rick" wrote:
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- Hide quoted text -


- Show quoted text -


thanks that worked
Rick