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

Brian,
See reply to your earlier posting.

Patience is a virtue!

" wrote:

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