Vlookup query

[RossB1010]

I have some data where i need to use a vlookup to get from one column to another, i attach a screen shot of the data and i need to get the following;

I have data in column c which i need to match the main list in column F, the data that needs to be assigned where there is a match is the data that comes from column E

Hope that makes sense!

Cheers

 

[Aladin Akyurek]

Looks like:

=INDEX(E:E,MATCH(C2,F:F,0))

 

[Special-K99]

You cant attach files on this forum.

=index(e$1:e$1000,MATCH(c1,f$1:f$1000,0))