IFERROR + VLOOKUP: if cell contains value, return adjacent value to new column

[gillianarm]

​I'm using VLOOKUP to search column A for a specific price type, to return the value in column B (Attendance) to column E (Adult Admission). I want only the numbers listed next to Adult Admission in column E, but by using A2, it copies over all Attendance counts (image 1). If I change "A2" in the formula to "Adult Admission",it lists the correct numbers, but down the entire column (image 2). IFERROR is included so that if the value does not match, it returns a blank cell to column E. I found a similar formula on Stack Overflow (excel - Find value from one cell, copy value from cell near to that cell and paste it to another sheet - Stack Overflow), but can't figure out what I need to change. Thank you!

[/URL]CaG]Capture 5 by Gill Armstrong, on Flickr[/IMG]Capture 2 by Gill Armstrong, on Flickr[/IMG]e by Gill Armstrong, on Flickr[/IMG]

 

[NikolaJovanovic]

Does this sole the problem?

=IF(A2="Adult Admission",B2,"")

 

[gillianarm]

It sure does! And it's so much simpler. Thank you very much for your help with this. I really appreciate it.

 

[NikolaJovanovic]

I'm glad it works.