|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 17th, 2002, 09:59 AM
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 13
|
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
|
|
|
|
Apr 17th, 2002, 10:14 AM
|
#2 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Monterrey, Mexico
Posts: 1,433
|
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))
__________________
Kind regards, Al Chara |
|
|
|
|
Apr 17th, 2002, 10:21 AM
|
#3 |
|
Board Regular
Join Date: Feb 2002
Location: Calgary, Alberta Canada
Posts: 2,065
|
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),"") |
|
|
|
|
Apr 18th, 2002, 02:09 PM
|
#4 | |
|
New Member
Join Date: Apr 2002
Posts: 13
|
Quote:
|
|
|
|
|
|
Apr 18th, 2002, 02:10 PM
|
#5 | |
|
New Member
Join Date: Apr 2002
Posts: 13
|
Quote:
|
|
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
