(vlookup)

  • Thread starter Thread starter Don Guillett
  • Start date Start date
Can you help...I have "RegQlist" that in B2-Z800 has a
result of cells in the RegQList how can I force Cell A2 to
look for that MATCH from another sheet named "Combo" that
has (5) differant manufactures.

I tried using =(vlookup)(B2,Combo!A2:Z200,6,FALSE) in a
effort to compare B2 of "RegQList" with any cell in
the "Combo" sheet that has that same data in its cell. Am
I even close?

Any help is appreciated.
 
Krefty,

Your cod
Code
-------------------

=(vlookup)(B2,Combo!A2:Z200,6,FALSE
-------------------
does not require brackets around the vlookup and translates as follows:

1. Look for the value of the B2 cell in Sheet1 within the Comb
worksheet using its column A between row 2 and 200.
2. When you have found the value then return the value that is i
column 6 of the same row
3. Only look for an exact match

The important thing about VLookup is that it always looks in the firs
column of the reference range for the match to B2.

I have attached a simple example of the use of vlookup such that if yo
put a value between 1 & 5 in cell B2, the formula in A2 looks for
match in the table below and returns the answer from its column 2.

HTH

Gordo

Attachment filename: vlookup.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39441
 
Back
Top