Looking in Ranges

B

Brian.Hastings82

Hi guys, hopefully you can help.

Spreadsheet set out as follows....

Cell A1: Persons name
Cell A2: Drop down list Z1,Z2,Z3,Z4
Cells B1:B10 All drop down lists with Z1,Z2,Z3,Z4

I need some kind of IF function to look up the range B1:B10 and if
this range includes the value in A2, the cell should equal A1. If not
should be blank.

Thanks

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top