Vlookup funtions

K

Kel

Hi I am trying to lookup a value on one worksheet, match to a second
worksheet then pull in a text value from the second worksheet to the first
worksheet.

Thanks Kelly
 
N

Niek Otten

Indeed VLOOKUP probably is what you need.

If you'd like to have somewhat more detailed support, please supply somewhat more details about your requirements.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi I am trying to lookup a value on one worksheet, match to a second
| worksheet then pull in a text value from the second worksheet to the first
| worksheet.
|
| Thanks Kelly
 
K

Kel

I have the same code(numeric) on two worksheets. One A it has more detailed
information and the code could be listed more then once in a column. On B the
code is only listed once but also has a name that is assigned to the code. I
need to get the name (text) assigned to the first worksheet.

Thanks
 
D

Dave Peterson

Say your code is in A1 of Sheet1 and Sheet2 contains your column of codes (in
column A) and Names (column B).

You could use:

=vlookup(a1,sheet2!a:b,2,false)

or to avoid a few errorw if there wasn't a match:

=if(a1="","",if(iserror(vlookup(a1,sheet2!a:b,2,false)),"No Match!",
vlookup(a1,sheet2!a:b,2,false)))

(all in one cell)

Debra Dalgleish has lots of notes on =vlookup():
http://www.contextures.com/xlFunctions02.html
 
Top