Insert a column in which you concatenate the two key columns, and do a VLOOKUP with concatenated cells

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ramalana" wrote in message
...
|
| 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
|