help with employee ID number lookup

JMITCH26

Board Regular
Joined
May 18, 2005
Messages
84
Is there way In excel I can type a name in cell A1 and have it find the employee ID number from a List and post it in Cell B1.

Example:
Type there name into A1. Then B1 will look at the list in Q50:Q75 then find the employee Number in R50:R75 and post it into cell B1
Type there name into A2. Then B2 will look at the list in Q50:Q75 then find the employee Number in R50:R75 and post it into cell B2

...A1...............B1
Tom Sebby .... 21
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64


Q50.................R50
Tom Sebby .... 21
Sandy Miller.....18
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64
Pam Bowmen....72
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Try placing the following formula in cell B1 and drag-copying it down as needed:

=VLOOKUP(A1,$Q$50:$R$75,2,FALSE)
 
Upvote 0
Yep.

There are several ways to do this, your basic VLOOKUP should do it, something like this

=vlookup(A1,$Q$50:$R$75,2,false)

Put this in B1, then copy it down column B as far as required.
 
Upvote 0
Try this:

Code:
=IF(ISERROR(VLOOKUP(A1,$Q$50:$R$75,2,0)),"Not Found",VLOOKUP(A1,$Q$50:$R$75,2,0))

You can change the "Not Found" portion to be whatever you want it to say if it can't find it.

Put in B1 and copy down as necessary.
 
Upvote 0
Is there way In excel I can type a name in cell A1 and have it find the employee ID number from a List and post it in Cell B1.

Example:
Type there name into A1. Then B1 will look at the list in Q50:Q75 then find the employee Number in R50:R75 and post it into cell B1
Type there name into A2. Then B2 will look at the list in Q50:Q75 then find the employee Number in R50:R75 and post it into cell B2

...A1...............B1
Tom Sebby .... 21
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64


Q50.................R50
Tom Sebby .... 21
Sandy Miller.....18
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64
Pam Bowmen....72
Put this formula in cell B1 and copy it down as needed...

=IFERROR(VLOOKUP(A1,Q$50:R$75,2,FALSE),"")
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top