LOOKUP Function for Work Spreadsheet

[thestones757]

Hey guys,

I am managing an excel sheet for work. People order items for office supplies and we log it on a sheet. Each staff member corresponds to a department's account number. I have set up columns with first names, last names, and combined for each staff member with their corresponding account number in the following column. Where we enter the data, I can either split it up into first name, last name, or I could do it combined. However, either way is not getting me what I want. The initial problem started because there are multiple people with the same first name so the lookup function was not resulting with what I wanted. Now I can't seem to come close. I have messed around with the MATCH function inside of LOOKUP (even looked at VLOOKUP and HLOOKUP) but nothing seems to work. Right now I have:

LOOKUP(name,column of names,column of account numbers)

this is not working and I was wondering if anyone could give me some insight on what to do? Thanks!

 

[hiker95]

thestones757,

Welcome to the MrExcel forum.


What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net

 

[Haseeb Avarakkan]

Hi,

If you can provide some sample data that would be helpful. See my signature to post your sample.

 

[Dryver14]

this may help

Excel Workbook
	A	B	C	D
1	john	smith	john smith	123456
2	john	smythe	john smythe	123457
3	bill	withers	bill withers	123467
4	bell	withers	bell withers	123567
5	mary	jane	mary jane	123333
6
7
8
9
10
11	first name	Last name	Account number
12	john	smythe	123457
Sheet1

 

[thestones757]

Thank you for this post. What does the 2 refer to? I tried using this formula and it responded with #REF. I believe it is very close to what I am looking for though, I really appreciate it, hopefully there is a quick fix that will get it returning what I am looking for.

 

[hiker95]

thestones757,

It would really help us to find a quick solution if we could see your data.


What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

If you are not able to give us screenshots, see below in my Signature block: You can upload your workbook to Box Net