LOOKUP follow up (pull only specific column)

[donyc]

Hi all, its me again with my LOOKUP questions... I did some testing and the previous stuff works great but now I am stuck on below example..

Attaching update worksheet..I am pulling # via lookup but I only want it to pull only for specific city which is in another column..might sound easy but I tried to edit the formula from something similar and it kept breaking for me..

Thank you all again for everyones input, it has been so helpful, I really appreciate it

[donyc]

figured will post the formula I use... beating my head into the wall still trying to figure this out...

I need to figure out how to only LOOKUP values for the column 13 city "NEW YORK" but ignore all others

Please Login or Register  to view this content.

[donyc]

just bumping this up.. if anyone has some input would very much appreciate it.. really stuck on this part on finishing the project and need some help... thanks so much