View attachment forum attachment.xlsx
I have a list of existing sizes L2:M50
I have a user input form: B2 and B3 (length, B4 doesn't pertain)
I want to be able to have a user enter dimensions in B2 and B3 and have the spreadsheet tell them whether that size exists in the data range L2:M50. This is a very small portion of the data range(for demonstration only). The full data range is 500 rows and growing.
I've tried VLOOKUP, and INDEX with MATCH, but haven't got it. I've also looked at TABLE.
Running EXCEL 2013
Any suggestions would be greatly appreciated, and thank you in advance.
I have a list of existing sizes L2:M50
I have a user input form: B2 and B3 (length, B4 doesn't pertain)
I want to be able to have a user enter dimensions in B2 and B3 and have the spreadsheet tell them whether that size exists in the data range L2:M50. This is a very small portion of the data range(for demonstration only). The full data range is 500 rows and growing.
I've tried VLOOKUP, and INDEX with MATCH, but haven't got it. I've also looked at TABLE.
Running EXCEL 2013
Any suggestions would be greatly appreciated, and thank you in advance.