View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default VLOOKUP using 2 Cells

=VLOOKUP($B$2&$B$3, 'Apr Sups'!$B$2:$J$13,6,0)

Presume it's ensured that the vlookup's match col B ie 'Apr Sups'!$B$2:$B$13
does contain the concatenated strings for correct matching? You might want to
check that. Also maybe try a TRIM to clean up the concat strings if you are
getting #N/As where apparently there should be matches.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---