View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bharat Saboo
 
Posts: n/a
Default use of vlookup in case of multiple column check

Hi

I would like to do the following :

In sheet 2
A1 = "SE"
B1 = "1"

In sheet 1 I need to check if the same exists as a combination. In sheet 1
also the data is stored separately like
A1 = "SE"
B1 = "1"

Kindly let me know how to go about it using the vlookup function.

Thanks