If there's no match, then you'll see #n/a.

You can hide those errors by:

=if(iserror(vlookup(b1,sheet2!a1:c216,2,false)),"" ,
vlookup(b1,sheet2!a1:c216,2,false))

(It looks for the error and if found returns "" (looks blank). If no error, it
retrieves the matching value.)

sbellybutton wrote:

Sheet1 (source)
b
22 #N/A
55 #N/A
b
26 #N/A
5
3
Sheet 2 (table)
b 0
161 d
162 e
163 E
164 g
165 h
166 i
167 j

I am trying to fill in blanks on sheet1 according to table..

"Dave Peterson" wrote:

I put the table in Sheet2 in A1:C216.

I put something in B1 of sheet1 that matched that first column in the table in
Sheet2 (A1:A216).

Then I used this formula
=vlookup(b1,sheet2!a1:c216,2,false)
to return the value in column B of sheet2 when B1 matched the value in A1:A216
of sheet2.

I'm not sure what you did. You may want to explain it in more detail.

sbellybutton wrote:

I tried both formulas and recieved the same answer then notices the numbers
in col.A are not alligned the same as the numbers in col.A on the table
sheet! Feeling retarded HELP

"Dave Peterson" wrote:

Maybe

=vlookup(b1,sheet2!a1:c216,2,false)
and copy down the column

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())

sbellybutton wrote:

=VLOOKUP(B1:B730,Sheet2!A1:C216,2,1) returns #N/A. What am I doing wrong?
Row1 of my table is #s and row2 is letters. I need the 730 cells in rowB to
equal what is in my table! Help.

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson