Lookup matching value

[Montoro22]

Hello,

So I'm trying to look up the a value and provide the name in an adjacent cell that corresponds to it. For instance I'm looking for the number 5 in a column and what the company name whose number that belongs to. Any suggestions???

Thanks it's much appreciated!

Rob

[Pepe Le Mokko]

Perhaps the VLOOKUP function?

[Montoro22]

I tried it but sometimes it returns the wrong value, because of the other functions I have in there some of the cells have #div/0 in them which for some reason throws it off.

[Pepe Le Mokko]

Try =IFERROR(VLOOKUP(your_conditions),"") which will trap the errors ( also the N/A of course)