| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use
I have two worksheets.
Worksheet 1 In column A1, I have the value SERVER1 In column A2, I have the value SERVER2 WORKSHEET2 Somewhere in column A, I have the value Sever1 Somewhere in column A, I have the value Server2 In column B I have a number 8.1.1 that coincides with the server name in column A (Server2 value might be 8.2) I want to take the value located in coulmn B that associated with Server 1 (wherever it might be in column A) and put it in cell B1 in Worksheet 1. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing two spreadsheets using vlookup and compare | Excel Worksheet Functions | |||
| Compare Old & New Product List (i.e. VLOOKUP) | Excel Worksheet Functions | |||
| can i use filters to compare data instead of vlookup? | Excel Discussion (Misc queries) | |||
| Using Vlookup to compare and validate data | Excel Worksheet Functions | |||
| using VLOOKUP to compare 2 columns to find new information | Excel Worksheet Functions | |||
Threaded Mode
