V
Vanessa Simmonds
Good Morning,
I want to lookup for value in a spreedsheet and return a certain row value.
For example:
A B C
1 David Age 31
2 Address 31 Yew Tree Drive
3 Mobile Number 07800726762
So I want a formula that will look for David on Column A and return his
mobile phone number on column C.
I tried to use: Vlookup(A1,A:C,Index(A:C,3,3),0) but it is not working.
Can someone help me, please?
Best Regards,
Vanessa
I want to lookup for value in a spreedsheet and return a certain row value.
For example:
A B C
1 David Age 31
2 Address 31 Yew Tree Drive
3 Mobile Number 07800726762
So I want a formula that will look for David on Column A and return his
mobile phone number on column C.
I tried to use: Vlookup(A1,A:C,Index(A:C,3,3),0) but it is not working.
Can someone help me, please?
Best Regards,
Vanessa