View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ramalana ramalana is offline
external usenet poster
 
Posts: 1
Default Multiple VLOOKUP


Hello

I am trying to return a value based on a multiple VLOOKUP

i.e. spreadsheet contains multiple lines for given value, say 322654,
and also multiple lines for second lookup value of 015, although there
will only be one 015 for 322654. I would like to return a related cell
that fulfills both of these conditions.

Alternatively perhaps I could use a VLOOKUP with an IF function built
in, any ideas please let me know.

Many thanks


--
ramalana
------------------------------------------------------------------------
ramalana's Profile: http://www.excelforum.com/member.php...o&userid=36949
View this thread: http://www.excelforum.com/showthread...hreadid=566586