| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Cells
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Match Cells
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Match Cells | Excel Worksheet Functions | |||
| Look for a value in two cells and match it with another | Excel Discussion (Misc queries) | |||
| Match cells with cells on another workbook | Excel Worksheet Functions | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
![Rick[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
