LOOKUP2.jpg

This is what I have come up with so far but returning an error

=IF(ISNUMBER(SEARCH(C59, C2:C)), VLOOKUP(C59,E2:E, 2))

Returning out of range error

I would like to do a search for the value in C59 (123456) in all of column C - if that value is found return the value in column E of that row

IE: search for 123456 - returns 56789 in E59

Thanks for you help

Mike