If, Then Function Help
I need help on a function that looks like this in pages 3.5.
Find Column "C" match to column "A", Insert Column "D" Value into column "B" that corresponds to the column "C" Match.
MacBook Pro, iOS 8.1.3
*Numbers 3.5
Apple Event: May 7th at 7 am PT
3 replies
It seems like i solved my own question. I used vlookup(a2,$C$2:$D$2478,2,false) into B. I think this is an excel formula but it worked anyways.
Hi G_Goodie,
Looks like you have it figured.
As Numbers supports multiple tables per sheet you could even put your C:D columns in their own table for less visual clutter.
quinn
If, Then Function Help