VLOOKUP & IF maybe???

mikvanoke

New Member
Joined
Oct 11, 2006
Messages
28
I have one worksheet that is constantly updated. I am creating new worksheets working off of the data input into the original (let's call the original WIP). The second worksheet (let's call this BILLING) is the one I need to build. Each person is to have their own sheets in BILLING and I want the information to be input automatically when WIP is updated. E.g. I am creating a BILLING sheet for DSH (the invididual's ID). I want that row that has DSH as the ID in column E to be replicated in BILLING for DSH. I don't need the entire row, just columns A,B & F replicated. If column E is someone else, I want it replicated in the appropriate sheet but to have nothing entered in DSH. Any ideas? Do I make any sense or am I babbling in Greek??? :confused:
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Hello & Welcome to the board :biggrin:

In order for a Vlookup to work, you will need to define initials in a hidden table
Book4
EFGH
1InitialsInitials
2RMARMA
3NJANJA
Sheet1


In E1 on your billing sheet, enter

=IF(F2=VLOOKUP(E2,E:F,2,FALSE)=TRUE,VLOOKUP(E2,E:F,2,FALSE),"Error")

You could then, do vlookups on the other cells in the billing sheet, to populate these cells
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Obviously - The vlookup will over two documents, just adapt the vlookup to read from the other document

Let me know how you get on

Mark
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963

ADVERTISEMENT

Sorry Mark, I don't understand what you mean by a 'hidden table'!

A hidden worksheet, sorry
 

mikvanoke

New Member
Joined
Oct 11, 2006
Messages
28
Unfortunately, you need to speak to me like an idiot or I'll keep asking dumb questions... soz!
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963

ADVERTISEMENT

This is a sample of a vlookup from another network file

=VLOOKUP(A17,'P:\Mcr Tech Team\[Marlice September 06 Figures.xls]Sheet1'!$A:$V,6,FALSE)
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
OK, first you'll need to build a table like the example i gave you, if this is not included in the document, the Vlookup has nothing to work from, therefore it needs to be present in the document

It can be hidden after

Are you familiar with Vlookup?
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
OK, first you'll need to build a table like the example i gave you, if this is not included in the document, the Vlookup has nothing to work from, therefore it needs to be present in the document

It can be hidden after

Are you familiar with Vlookup?

Unfortunately - I am just going into a meeting - back around 2pm
 

Watch MrExcel Video

Forum statistics

Threads
1,108,924
Messages
5,525,656
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top