Return a list of names based on IF function formula

**PRodgers4284** · 10-22-2009, 04:45 AM

I want to return a list of people names from the columns outlined below:

Forename1 - (Column E)
ForenameOther - (Column F)
Surname - (Column G)

Can anyone help?

**PRodgers4284** · 10-22-2009, 07:03 AM

I have tried the following but it isnt working properly:

Datasheet1 is the sheet where the data is stored.
"Range" is the column named range the VLOOKUP name will use.
"A13" is the VlOOKUP name that will be looked up and is in Datasheet2.
The VLOOKUP column i want to display from the datasheet is column 5

**NBVC** · 10-22-2009, 07:55 AM

Your two posts are totally different... different ranges, references, types of formulas?

Can you be more specific as to what you want without telling us formulas?

Posting a sample workbook would also be of great help.

**PRodgers4284** · 10-22-2009, 08:38 AM

Originally Posted by NBVC

Your two posts are totally different... different ranges, references, types of formulas?

Can you be more specific as to what you want without telling us formulas?

Posting a sample workbook would also be of great help.

NBVC My sample workbook is attachment, im trying to get the vlookup working on sheet2 but it isnt working correctly

**NBVC** · 10-22-2009, 08:48 AM

In D1, enter:

=COUNTIF($A$1:A1,$A$9) and copy down to D6

Then in B9:

=IF(ROWS($B$9:$B9)>MAX($D$1:$D$6),"",INDEX(B$1:B$6,MATCH(ROWS($B$9:$B9),$D$1:$D$6,0)))

copy down and over to next column.