IF Formula

[JoelBrown1990]

Hi there,

I need to know the correct formula for the following scenario:

In cell BP2 i need it to display the data in column BK if the data in cell A2 matches the data in column B - There is circa 7000 lines of data.

So what i need is: if cell A2 matches data in cells BK 2 - 7000, then display cell B (of the corresponding line)

Hope the above makes sense. Can send more information or an image if easier.

Many thanks in advance.
Joel

 

[hagia_sofia]

Do you mean something like this:

=IF(BK2:BK7000=A2,B2:B7000,"")

 

[JoelBrown1990]

=IF(BK2:BK7000=A2,B2:B7000,"")

Hi, Yes that does look like what i need. One last thing, if the data is across two sheets (both within one excel document), can i adjust the above formula to work?

Many thanks,
Joel

 

[hagia_sofia]

I do not see a reason why not provided the ranges are of the same size.