Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP help from yesterday's post
First of YOU GUYS ROCK!
the formula you gave me doesn't work though. I'm going to explain better he Sheet1 A B Server12 What version? (that's what I need to plug in here for the matches Server1 from sheet2) Server9 Server2 Sheet 2 A B Server1 Version9 Server2 Version10 Server3 Version12 I need a formulate that will look a cell A1 in sheet 2, find it's match in Sheet1 COLUMN A. Then take the value in sheet 2 column B (that matches the right server name) and places that value in column B on sheet 1. Thanks, Jess |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP help from yesterday's post
Put this in b1 and drag down.
=VLOOKUP(A1,Sheet2!A$1:B$3,2,FALSE) Note that there are no matches for 2 of the servers. Mike "jessshouse" wrote: First of YOU GUYS ROCK! the formula you gave me doesn't work though. I'm going to explain better he Sheet1 A B Server12 What version? (that's what I need to plug in here for the matches Server1 from sheet2) Server9 Server2 Sheet 2 A B Server1 Version9 Server2 Version10 Server3 Version12 I need a formulate that will look a cell A1 in sheet 2, find it's match in Sheet1 COLUMN A. Then take the value in sheet 2 column B (that matches the right server name) and places that value in column B on sheet 1. Thanks, Jess |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Problem ( related to earlier post of using if an Vlookup) | Excel Worksheet Functions | |||
VLOOKUP post UDF (#DigitsFirstID) creates error | Excel Worksheet Functions | |||
Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) | |||
follow-up from yesterday's "creating formulas" | Excel Worksheet Functions | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel |