If cell A1 is in column B then place value of cell C into D

[selkie10]

Example001.xlsheet1 is in column A of Sheet2 (e.g. at A3) then place value of Sheet2 cell B3 into Sheet1 B2.

Does that make sense? Basically if a value shows in another column I need a value from another row same as where the question value is found pasting to another cell.

Hello, my first post so apologies if in wrong area or if has been asked before. I need a little help generating a comparison sheet to show required values.

Any advice or assistance much appreciated, would prefer to stick to formulae if possible rather than creating macros unless macros are the way forward.

example:

"4 Long Road" in 'Sheet1'!A3

Find 4 Long Road in 'Sheet2'! column A

'Sheet1'!A3 is in 'Sheet2'!A5 so copy 'Sheet2'!B5 over to 'Sheet1'B3

[DGagnon]

you can do this with a vlookup, try this formula in B2 and fill down, you may need to change the format to date

=VLOOKUP(A2,Sheet2!A:B,2,0)

[Paul]

Hi Selkie, welcome to the forum.

You can use VLOOKUP for this task. In B3 enter the following formula:

=VLOOKUP(A3,Sheet2!A:B,2,0)

You can then copy that formula (or fill) to the other cells in column B on sheet1 and it will lookup their corresponding values. You may need to format the cells in column B to Date, otherwise you may see numbers like 40960 (serial date value).