View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mustafa.nuriddine@gmail.com is offline
external usenet poster
 
Posts: 2
Default relating 2 sheets

Hi,

I have two sheets where I have to drag data from the first sheet to
the second one which plays the role of a report.
I am not being abele to get the exact vlookup formula.

to clear myself take this exapmle,

Sheet A which contains the data
Sheet B where the results should appear


if a cell in sheet B (D5) matches with a cell within a column in sheet
A (K6), then E5 in sheet B should equal L6 in sheet A.

I hope it is clear enough,

please need help.

Abosteif