Thread: Vlookup
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eman via OfficeKB.com Eman via OfficeKB.com is offline
external usenet poster
 
Posts: 2
Default Vlookup

Thanks T. Valko, It works

Best

T. Valko wrote:
Enter this formula on sheet2 C2:

=VLOOKUP(A2,Sheet1!A$2:C$20,3,0)

Copy down as needed

Hi,
I wanted to use IF and Vlookup formula to find data from Sheet1 into

[quoted text clipped - 9 lines]
Can anyone assist me?
Thanks


--
Emmanuel K. Agbovi

Message posted via http://www.officekb.com