Abovemypaygrade
New Member
- Joined
- Jun 6, 2013
- Messages
- 12
Hi guys,
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.
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.