vlookup tables

[pao]

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

 

[Al Chara]

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))

 

[Dave Patton]

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),"")

 

[pao]

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),"")

 

[pao]

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),"")