Two way Vlookup

[Sirfyaad]

Hi,

Please help. How can use two way lookup whithout helper column in the appsheet form. i want voolup mrp base on below screenshot. 

example

[1minManager]

Dont understand, please rephrase

[Sirfyaad]

I want that when the channel column and Sku column are equal, then the column with MRP should be auto filled. 

ref sheet name "mrp list"

entry form sheet name "scan data"

[1minManager]

So the start of this would be to have a App Formula for [Form MRP] to be

IF(

[SKU]=[[Channel vl2],

<put in here what you want it to be>,

""

)

[Sirfyaad]

I am using this function ANY(SELECT(Selling Price List[PRICE],[_THISROW].[SKU] = [Item SKU Code], TRUE)) but this not helpful. 

I want that when the [SKU] column and [channel] match with my ref data, then the [selling MRP] in the [MRP] column should be auto filled. 

[1minManager]

You're probably going to have to show us the entire list of columns in each table so we can best help.  Please post some screenshots of Date->columns for the tables your referencing

[Sirfyaad]

ANY( 
  SELECT(Selling Price List[PRICE], 
    AND(
     [Item SKU Code] = [_ThisRow].[SKU],
     [Selling Channel] = [_ThisRow].[CHANNEL]
    )
  )
)