Lookup Coommand

[maddyrafi1987]

sorry see down

[maddyrafi1987]

I have attached 02 excel sheets, 1 sheet name is original another sheet name is working, now i want to workout in working sheet.
In working sheet birth year col. is blank, in original sheets birth sheets is filled now I need to compare both sheets and bring in working sheet output birth year column need to fill from comparing of original sheets. I think lookup command is used for this. But i don't know how to do easily ?
So may i request you to please provide me the clear solution.

Kindly note both sheet common col. is borrower id. And if cell is blan in working sheet it need to be fill automatically some year.

[Xandler]

On the working sheet in F2

Please Login or Register  to view this content.

and copy down

[maddyrafi1987]

good. but explain. i want to know about this briefly

[Xandler]

Vlookup isn't as good as a Nested Index/match formula, so I converted the it into it like so. F2 and copy down

Please Login or Register  to view this content.

[Xandler]

It appears my formula is a tad off, I probably have used the wrong references...that's what I get for not checking my work before posting