CODEWITHSUNDEEP
excel
Faraz Hussain
Faraz Hussain

Reputation: 13

EXCEL: How to find a cell value in column and copy the found value in another cell

I need to know how can i find a value of A1 in C:C and copy the value of found cell into B1.

For example:

enter image description here

Upvotes: 0

Views: 84

Answers (3)

MGP
MGP

Reputation: 2551

Set this in B1:

=INDEX(C:C,MATCH(A2,MID(C:C,4,LEN(A2)),0))

Enter this formula with Ctrl+Shift+Enter, since this is an array formula. and drag down.

Upvotes: 1

Sid
Sid

Reputation: 317

Use VLookup 

=VLOOKUP("File="&A1,C$1:C$4,1,FALSE)

Upvotes: 0

openshac
openshac

Reputation: 5165

Try setting B1 to:

=INDEX(C:C, MATCH("File=" & A1, C:C, 0))

You could also use the VLOOKUP() function.

Upvotes: 0

Related Questions