Lookup Function

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

I have a workbook that contains two worksheets.

In worksheet one I have a list of numbers assigned to different people.

In worksheet two I have a list of the numbers, and some varoius types of
information that go along with them.

Back to worksheet one, I want a column that will take a look at the person's
number, find it in worksheet two, and put something from one of the other
columns on worksheet two back in worksheet one.

I've tried using this formula:

=LOOKUP($E:$E,Combos!$A:$A,Combos!$B:$B)

and get this error: #N/A

Column E (on worksheet one) has a list of numbers, as does column a on
worksheet two (Combos).

If I change one of the numbers to a letter on both worksheets (for instance
replace 2283 with an "A" on both worksheets, I get the corresponding data to
show up where I want it to.

How do I get it took lookup numbers instead of just letters?

Thanks
 
One way:

F1: =VLOOKUP(E1,Combos!$A:$B, 2, FALSE)

and copy down as far as necessary.
 
Oops, I was focusing on the first argument.

It sounds like one or the other of your lists are Text rather than
numbers. Try copying a blank cell, selecting each list, and choosing
Edit/Paste Special..., selecting the Values and Add radio buttons.
 
Thanks, that worked. I had one additional error that I noticed (I was in
row 2 (row 1 was headers), so I had to change the E1 to E2, and everything
worked fine.

Thanks again.
 
Back
Top