Thanks:  0
Likes:  0

1. I have a column of species names, common names and latin names. I would like the vlookup to look in both to find name and return latin my formula is as follows =vlookup(c2,species!a2:c813,3,false) this works as long as just looking at species name. I change it to =vlookup(c2,species!a2:c183,3,false) and it will look at common names I need both at once time

2. Try the following formula:
=IF(COUNTIF(\$A\$2:\$A\$183,C2)>0,VLOOKUP(C2,\$A\$2:\$C\$183,3,FALSE),VLOOKUP(C2,\$B\$2:\$C\$183,2,FALSE))

3. try

=IF(COUNTIF(Species!A2:A813,C2),VLOOKUP(C2,Species!A2:C813,3,FALSE),"")&IF(COUNTIF(Species!B2:B813,C2),VLOOKUP(C2,Species!B2:C813,2,FALSE),"")

4. On 2002-04-17 09:21, Dave Patton wrote:

try

=IF(COUNTIF(Species!A2:A813,C2),VLOOKUP(C2,Species!A2:C813,3,FALSE),"")&IF(COUNTIF(Species!B2:B813,C2),VLOOKUP(C2,Species!B2:C813,2,FALSE),"")

5. On 2002-04-17 09:21, Dave Patton wrote:
this works great

try

=IF(COUNTIF(Species!A2:A813,C2),VLOOKUP(C2,Species!A2:C813,3,FALSE),"")&IF(COUNTIF(Species!B2:B813,C2),VLOOKUP(C2,Species!B2:C813,2,FALSE),"")

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•