Thread: Vlookup multiple criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NBVC[_143_] NBVC[_143_] is offline
external usenet poster
  
Posts: 1
Default Vlookup multiple criteria

Try


Code:
--------------------
=IF(A1="","",IF(A1="Hispanic or Latino",IF(B1="White","Hispanic or Latino","Hispanic or Latino (all other races)"),IF(B1="White","White","African American")))
--------------------


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123943

Reply With QuoteReply With Quote