VLOOKUP Function using multiple worksheets

F

Fiona

Received advise previously on this (thanks). However, I
need to look up entries in another separate worksheet and
it won't work. I'm using:

=VLOOKUP('Entry 1 - New Clients'!A2,'Entry 1 - New
Clients'!A2:O20,2,FALSE). It returns the persons name
(great) but I need to transfer across other details too.

Basically I'm summarising one worksheet onto a specified
format in another. In addition, I somehow want it to only
show me those clients in 'Entry 1 - New Clients' if the
corresponding column (N) has the entry of "Active".

Is this possible??
Fiona
 
B

Bob Phillips

Yes, just re-use the formula in another cell with a different column index

=VLOOKUP('Entry 1 - New Clients'!A2,'Entry 1 - New Clients'!A2:O20,3,FALSE).

note the ,3 not ,2

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP + IF STATEMENTS 6
IF function involving VLOOKUP 8
Vlookup using multiple worksheets 2
VLookup Function over Multiple Worksheets 3
Linking multiple worksheets in one workbook 2
Excel 2003 Referencing multiple worksheets 3
Lookup Data Across Multiple Worksheets 4
Fill Data across multiple Worksheets - Formulas 1

Top