Vlookup funtions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kel - 21 Aug 2006 19:26 GMT

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

Reply to this Message

Niek Otten - 21 Aug 2006 19:36 GMT

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.

Signature

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

Reply to this Message

Kel - 21 Aug 2006 21:15 GMT

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

> Indeed VLOOKUP probably is what you need.
>
[quoted text clipped - 5 lines]
> |
> | Thanks Kelly

Reply to this Message

Dave Peterson - 21 Aug 2006 21:44 GMT

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

> 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
[quoted text clipped - 18 lines]
> > |
> > | Thanks Kelly

Signature

Dave Peterson

Reply to this Message