Report cell content from a row looking at 2 other cells data in same row.

[Turbo68]

I have a big sheet of lots of data that I want to peel some info out of. In my DATA sheet my columns are as such:

A1 B1 C1 D1 E1 F1 G1 H1
Store Model Name IP Pub Port 1 Port 2 Net Online

In col A there is lots of numbers and there are duplicates.
In col B there is 4 types of models.

It is in another sheet that I want to report the contents using a certain store number and a certain model and give me what is in col E and F in that corresponding row.

The results sheet would be Store and model in A2 and B2 and formula needs to be using that info to fill D2 and E2 with contents of those corresponding Col E and Col F in my DATA sheet.

I know VLOOKUP is not enough and can’t wrap my head to what I need to do with MATCH or some other formula uses.

Thanks

 

[ranman256]

you cant filer on A, and B for store & Model?

 

[Turbo68]

you cant filer on A, and B for store & Model?

Yes, I can filter that to get that. But I am using another sheet in that workbook to view that info when i type a store into A2 and B2 and it populates D2 and E2 from my data sheet