I'm trynig to retrieve the data from a cell that is next to a cell with a certain value.
Here's what I'm talking about:
Apple 1
Boy 2
Cat 3
Dog 4
If cell a6 is 4, then I want cell a7 to display "Cat".
This is probably really simple, but I'm pretty new to excel and couldn't figure it out.
Thanks in advance!
Here's what I'm talking about:
Apple 1
Boy 2
Cat 3
Dog 4
If cell a6 is 4, then I want cell a7 to display "Cat".
This is probably really simple, but I'm pretty new to excel and couldn't figure it out.
Thanks in advance!