VLOOKUP help from yesterday's post

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

First of YOU GUYS ROCK!

the formula you gave me doesn't work though. I'm going to explain better
here:

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

lookup help! 5
Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use 3
Vlookup & relative cell reference? 2
vlookup or index for text on 2 worksheets 2
How to Populate Data from a table to another 0
help with a vlookup 2
trying to match text in 2 worksheets 1
VLOOKUP Function to return values in multipal Columns 6

Back
Top