View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K
 
Posts: n/a
Default HOW CAN I PULL INFORMATION FROM ONE SHEET TO ANOTHER IF NOT #

I hope you can help!!

I need a formula that will take info from sheet A column K only if sheet A
column E is equal to sheet B column E. I need it to paste into Sheet
B column K exactly as shown in sheet A column K.

I tried using a Vlookup formula but I got #N/A and I am not sure if that is
because there is text as opposed to numbers or if I am using the wrong
function entirely.

Your help would be appreciated.

Thanks,
K