#### Abovemypaygrade

##### New Member

- Joined
- Jun 6, 2013

- Messages
- 12

Im pretty new to the whole vlookup functions of excel, so what im asking may not be achievable with that function in particular but its what i think is most accurate.

I have a spreadsheet which i need to get data with a certain criteria off and onto another spreadsheet.

A simplified version is:

Customer Reference Customer Name Red Blue

I want to search by Red and if there is a y in that column then it will bring across the customer reference and the customer name onto the new spreadsheet.

I only want the Customer details for the customers which have a y in the red column. I'd prefer it to be a formula as there may be future customers that will apply.

Is that possible with a vlookup?

Am i completely wrong and it should be an IF function, ie IF red = y then copy Customer Reference and Customer Name.

Sorry for being all over the place like i mentioned pretty new to all these more advanced functions of excel.

Thanks for any help.