Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Ok, tedious question so apologies from the off.
I have some data in cell F558, this data is repeated intermittently throughout colum F.
I normally manually enter data into cell in column H that relates to this.
So, if cell F558 contains "burk". Column H would contain "that's me" Is there a forumula that can be entered into H558 for looking back up column F for a reoccurance of "burk" then displays the data in the associated column H cell?
F252 = Burk / H252 = Thats me
F558 = Burk / H558 = (formula displays H252)
How did life come to this....
The easiest way would be an IF statement, cell H252 would contain;
=IF(F252="burk","that's me","")
then for the second part, cell H558 would be something like;
=IF(F558="burk",H252,"")
=IFERROR(VLOOKUP(F558,$F$1:$H557,3,0),"")
And copy up/down as req. Will look through list above where you're inputting
Thanks both
That's sorted it